Vertical format to horizontal format

[deanstein]

Hi all,

The attached example shows exactly what I need to do. The existing data is currently in an unusable format with the different years one on top of each other. I need these to be spread out across the columns as shown. In the example i've basically shown how it would be done if I copied and pasted every row. In reality I can't do this because there are thousands of rows and the data is updated on a monthly basis.

Please help with a possible formula! thanks in advance.

[deanstein]

Anybody?

[FDibbins]

see if the attached is what you want? I used a helper row and helper column.

[deanstein]

Exactly as I wanted it! thank you very much

[FDibbins]

happy to help, and thanks for the rep