Power Query - Dynamically Split into Columns

Dynamically Splitting a delimited column in a dataset into various columns for each value is quite useful to learn. in this tutorial i show you how to dodge Power Query's default hard coding and make the titles and the splits dynamic based on the portfolio's of some value investors.
#data #dataanalytics #portfolio #powerquery #powerbi #excel #mquery #m

Links
File Used in video

My Site

Links to Functions used

[Softwaretrain]

Thank you, another way is sort descending custom column then split column and just remove last part of the function. It will create column based on first row.

[alexrosen]

Super useful tutorial and I really appreciate the added link for the file used in the video so I can follow along on a practical level 👌🙏👌

[roywilson]

Thank you, nice video. I would personally have added a few extra steps so the query turns out a proper dataset then set it up as a function that can be invoked whenever new files are added to the portfolio directory.

[excel-k-sir]

Hello Dear, Thanks for the nice video. I have a column with multiple line items where I want to split the column into two columns the only criteria is that the split has to happen from the fourth instance of the Space from Right to left. I know it is possible but don't know how to do it.

[ShckTV]

can you sort the stocks before the split so the same stock appears is the same column per row? i.e. null null HIJ in one row and another ABC null HIJ