Forum Discussion
Multi transpose from one column
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/EcJEphvMqcdGo4MbaM8iMw8BJoC4iEjqZAS7reLxZCeIlA?e=PKVWGm
Thanks and regards,
Michael
just for the data you shown
=#table(4,List.Split(PreviousStepName[Column1],4))
Nice approach, it worked, thanks a lot!
6 Replies
just for the data you shown
=#table(4,List.Split(PreviousStepName[Column1],4))
This is awesome. Never thought of using List.Split ever. You taught me this trick. Thank you, so much.
it's my pleasure.
Thanks a lot for this elegant solution!
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)
Nice approach, it worked, thanks a lot!
