Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Rygar
Helper II
Helper II

Multi transpose from one column

Hi Community! 

 

I need some kind of multi transpose from a column:

Rygar_0-1661960260891.png

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

 

Thanks and regards,

Michael

 

2 ACCEPTED SOLUTIONS
wdx223_Daniel
Super User
Super User

just for the data you shown

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

View solution in original post

Nice approach, it worked, thanks a lot!

View solution in original post

6 REPLIES 6
wdx223_Daniel
Super User
Super User

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.

HotChilli
Super User
Super User

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!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors