Hi,
Thanks for your valuable inputs on previous occasions.
Just stuck with this one. I have some data in excel ( Master Sheet in attached file) which is in rows format. I need to transpose all the data in columns. As soon as a blank cell is encountered, the data till that blank cell gets transposed. Please help me with some macro as I have tons of rows to transpose.
Bookmarks