Forum Discussion
Rygar
Helper II
4 years agoMulti 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...
HotChilli
Community Champion
4 years agoAdd 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
Helper II
4 years agoNice approach, it worked, thanks a lot!