Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
just for the data you shown
=#table(4,List.Split(PreviousStepName[Column1],4))
just for the data you shown
=#table(4,List.Split(PreviousStepName[Column1],4))
Thanks a lot for this elegant solution!
This is awesome. Never thought of using List.Split ever. You taught me this trick. Thank you, so much.
it's my pleasure.
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!