Transpose first 5 rows of data into columns

[Mwoody_05]

Hi All,

I've seen this solved when it's only 2 rows, but I can't figure out how when there's more. I have data coming in in the following format.

And I need to transform it to the following format.

Thank you in advance!!

[Kamran1991]

Hi @Mwoody_05 

Please find the attached workflow, hopefully it will answer your query.

Thanks!

Kamran

[StephaneP · Accepted solution]

Hello @Mwoody_05 ,

Here a generic way of doing the process.

What ever is the number of header it will always work the same way. The idea is to separate header and data. Transpose the header and then, based on an ID, reconcile it with the data. Then it is generic.
What you have to do from 1 case to another is just adapt the numbers of row/ column you have in the header (and then in the foloowing process). Same thing from data.
The little trick is at the very import 1st step to check the "1st row contain data" that will then generate a sort of unique ID for the column (F1, F2, F3...) which prevent you from any error if your 1st header have duplicate labels.

Hope it helps

[Mwoody_05]

This is Awesome, Thank you so much!

[Mwoody_05]

I think this would have worked, however I have 96 metrics in my data so it would take a lot of appends. Appreciate you taking the time though. Very helpful!