Hi Everyone,

I'm having some difficulty getting a macro to transpose the data I have into multiple columns. Basically I want to keep the ID field as the first column and then take each column's data (including the header as a new column) and transpose into rows.

I've created an ouput sheet in the attached example to show you exactly what I mean.

PS - there could be more columns in the final version so I would need it to loop until all columns are transposed

Can anyone help with the macro to get me from the input to the output ?

Many thanks in advance.

Transpose columns to rows - help.xlsm