Transpose data macro

Here is the file , data on a1 to transpose as expected shown

Hi there,
not sure how urgent your request is, but here is a way to do it with formulas.
I start by creating a flag to bring all the "Unique values in". Filter and paste them.
The rest is just offset formulas to bring all the entries underneath it in.
Hope this helps.

Try this:-
The code assumes that there are Blank rows between each set of data in column "A".

Please Login or Register  to view this content.

Regards Mick

Great work Mick

Thank you Mick
Thank you too ImokatExcel

Can someone tune that good macro
As need data set going to next line

ImokatExcel meanwhile your file will play the roll

Yes for the assumption of that macro , yes the of the blank row is true

Perhaps Change:-

Please Login or Register  to view this content.

oops I don't know the abc of macro , I only know to plug and then run