rows to columns

[wetekunal]

Hello Friends,

I need help and it is a bit URGENT, i need a macro which would convert the data in column into rows...

I have worked on this data for last month or so, however used EDITplus to format and macro in EditPlus... But still some of the data is missing...

Can you please help me in this....

Any help would help...

PS: I need data to start from column B for every data on the same line as the first entry in that data collection.

Thanks,
Kunal Wete

[davesexcel]

Try this,

Please Login or Register  to view this content.

[wetekunal]

Thank You Dave,

This works for me... you are a life saver....