Transpose Data - VBA Array?

[lee2121]

Hi everyone,

What I'm trying to do is move the data transpose as below;

Sheet1 contains my origianl data which has values going across the sheet from column C to column AH i want this data to be displayed as per the example in sheet2.

sheet1.PNG

sheet2.PNG

I'm sure someone will have smart way of doing this i just can't figure it out.

[romperstomper]

You should be able to use this method: https://www.contextures.com/excelpiv...cedatafix.html

[MarvinP]

Hi Lee,

In newer versions of Excel is a tool called Power Query that has an UnPivot tool. Took me about 30 seconds to do this problem. See attached. Power Query is an Add-In for 2010 Excel, from Microsoft.

PQ Unpivot Easy Peasy.xlsx