Multi transpose from one column

[Rygar]

Hi Community! 

I need some kind of multi transpose from a column:

Example File here: https://edvadamsde-my.sharepoint.com/:x:/g/personal/adams_edv-adams_de/EcJEphvMqcdGo4MbaM8iMw8BJoC4i... 

Thanks and regards,

Michael

[wdx223_Daniel · Accepted solution]

just for the data you shown

=#table(4,List.Split(PreviousStepName[Column1],4))

[wdx223_Daniel · Accepted solution]

just for the data you shown

=#table(4,List.Split(PreviousStepName[Column1],4))

[Rygar]

Thanks a lot for this elegant solution!

[Vijay_A_Verma]

This is awesome. Never thought of using List.Split ever. You taught me this trick. Thank you, so much.

[wdx223_Daniel]

it's my pleasure.

[HotChilli]

Add an Index column

Add a custom column using Number.IntegerDivide to divide the Index Column by 4 (as you have groups of 4).

Add a custom column(name it Heading) using Number.Mod([Index], 4) to create the field which we will use for column headings.

Then remove the Index column

Then Pivot the Heading column (pick the original column for Values column and Don't Aggregate)

--

That's the method.  Have a go and I can help if you get stuck (There will be exact examples on this forum or the web too)

[Rygar · Accepted solution]

Nice approach, it worked, thanks a lot!