Transpose data of different lenghts

[batchjb69]

Hi

I have a performance extract from a system which has performance for multiple accounts but the data is off different lengths and shown vertically. I wish to move the data onto a new sheet but rotated(transposed) horizontally

Attached is a snapshot of the report that is usually about 20,000 lines. See input and output tabs.

Is there any way that a macro could be created to do this.

JB

Performance.xlsx

[Jamie.Reis]

Pivoting those data:
If you want to use the below without modification, delete your "Output" sheet first.

Please Login or Register  to view this content.

[mrice]

Maybe something like this?

Please Login or Register  to view this content.

[batchjb69]

Thanks any chance you can let me know how this works