Transpose from single row/multiple column to multiple row/grouped column

[kblake]

Hi i have some data in a single row with similar column headings but want to transpose it to a grouped set of columns ending up with multiple rows.

See spreadsheet attached

Thanks

[Emil_Kos · Accepted solution]

Hi @kblake,

I have created a solution for you:

The output is:

Hope this helps 🙂 

[messi007 · Accepted solution]

@kblake,

Please see below:

Even if you have a new columns it will works 🙂

Attached the workflow,

Hope that helps!

Regards,

[kblake · Accepted solution]

That's great thanks

[kblake · Accepted solution]

This also works a treat - thanks