Power Query - Dynamically Split into Columns

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 👌🙏👌

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

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.

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.