How to automate transpose using formula or macros

Friends

So I have this spreadsheet where there are thousands of sets of data in the first column consisting of name, address, phone, fax & email. All these data are grouped together. Kindly refer to the attached image & spreadsheet for better understanding

All I want to do is transpose each set of data from the first column to their respective rows.

Is there a way I could automate this through a formula or a macro.

Please let me know...this will save me a lot of time and also money


Many thanks in advance!