Hi,
I have got a sheet with a large number of values such as below where H stands for heading. (I have used to "-" to put the data in proper lines)

H1-------H2---H3---H4
Data1----X
Data2----X
Data3----X
Data1---------X
Data2---------X
Data3---------X
Data1-------------X
Data2-------------X
Data3-------------X

I want to consolidate the data as below.
H1-------H2---H3---H4
Data1----X---X---X
Data2----X---X---X
Data3----X---X---X

Any idea? Any help at all will be very useful. I have no idea about Vb scripting. I have attached a sample file to illustrate my problem.

Thanks,
Nayak