Transposing data till blank cell - Excel 2007

[batrasunil81]

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.

Thanks in advance.