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!

Give this a try

Please Login or Register  to view this content.

Hi Mike

Thanks a lot for your response and for providing the code

I tried running it but couldn't make it run properly.

I have attached a sample seed of data from our actual sheet that we're trying to work on. On each set of data, you'll find that there's a year mentioned at the top of the set, we would want to have that removed as well.

My desired output is the one that's shown in the first row of the sheet.

I'd be very grateful If you could kindly show me how exactly to run the code on this sheet and also how it would look once the code is executed


Many thanks again!

Try this

Please Login or Register  to view this content.

This should work

Please Login or Register  to view this content.

Sorry my bad, I was working on something else and just turned that up without really looking at it. Try this

Please Login or Register  to view this content.