Unstacking Rows into Columns - Using M Code in Power Query

In this video, we will discuss a slick & efficient way to unstack rows in separate columns using M Code in Power Query

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[jorgerobertobalardingarcia]

Very good explanantion and clear step-by-step. I´m following your channel. Many thanks Chandeep!!

[wayneedmondson]

Good one Chandeep. After List.Split, I used Table.FromRows, as in:
let
Source = Excel.CurrentWorkbook(){[Name="Table18"]}[Content],
ListBucket = List.Split(Source[Data], 4),
MakeTable = Table.FromRows(ListBucket, {"Name", "City", "Age", "Phone"})
in
MakeTable
Just another approach. Thumbs up!!

[damionc]

Where do you learn this stuff? As usual mind blown.

[willm]

Dude Thank 😀😃😀 looking for this solution for a while thanks !!!!

[stretch]

Brilliant as usual! I just had this type of data problem come my way so I’m glad I could use the M code version to solve it, thanks Chandeep!

[andrewsinha]

Peace and love to you. Thanks and good luck in your life.

[mostafayeganeh]

Thanks so much, borther! It is really helpful.

[christophertauss]

Very cool - both methods, but, of course, I was really impressed with the M code method. Great explanation and a great demo of how M code can easily process lists and tables. M Code, though not initially all that intuitive, is amazing in its elegance and what it can do. Well done, Microsoft and thanks for the great presentation, Goodly. You make me very glad that I am a subscriber.

[guilouback]

man, you make usable tutorials. thank you!

[shrirajdeshpande]

Always comes up with super fantastic approaches

[JohnAdair-kj]

What column did you pivot on at mm 2:00 (Pivoted Column1)?

[danishnawaz]

Excellent, Plz post maximum videos on Power Query Vidoe..

[arne.munther]

Would love to see you solve more of these problems.
Here I am thinging of the ones in Chapther 13 of the book Master you data.

[KuldeepSingh-nqvi]

You are really champ of Power Query❤❤❤

[PurplePegasus]

Omg I literally have a project I can use thus solution for right now!!!!

[saikumarboga]

Hi, video is mind blowing, suppose if column is sorted like all texts are in upper records and all the numbers are started from end of text values, how to get the sort order which shown in the video from that?

[TheMoh]

Many thanks Chandeep.
You can do it in two steps only
List.Split & Table.FromRows
Regards
Mohammed from Algeria

[BhavyaGupta]

Sir both the approaches are Awesome 👏 Thanks for making such tutorials 🙂

In the second approach using M, can we directly use Table.FromRows after the split step, giving column names as list in second parameter ??

[ssurajkr]

DAX advanced course available? If yes link please

[johnedwards]

Chandeep, nice video. What would you do if the number of rows to unstack varied. I have an issue where I am unstacking an address. At time it has the first level and then immediately the city and state. at other times it has the first address, then say a suite number, and then the line with city and state. Therefore, it is at times three lines and at other times only two lines.