Forum Discussion
Solved
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/EcJEphvMqcdGo4MbaM8iMw8BJoC4iEjq...
just for the data you shown
=#table(4,List.Split(PreviousStepName[Column1],4))
Nice approach, it worked, thanks a lot!
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!