Forum Discussion
Splitting columns into multiple rows
To achive the desired result you can use index column: before appending datasets you create an index in each of them. After you append queries as new they will be listed one under another (so Dataset A and then Dataset B). However, because you index column, you can sort them in a desired way (once you're done, you can delete index column in the final dataset in case you don't need it anymore):
I also don't remember whether you start with 2 separate datasets or you have just one, which you first need to split. In attached pbix you'll find both option (when you select one of them, just delete the second)
Is it what you've been looking for? 🙂
Hi Ry009 ,
Thanks to @Sergii24 and @Kishore_KVN for the detailed explanations and steps. If you are still not clear, I have provided a pbix file for your reference, you can click "transform data" to enter the power query and then check the steps on the right side of the step column.
(1)Copy the original table to get Table 2, delete the redundant columns and then add customized columns.
(2) Copy the original table to get Table 3, delete the redundant columns, and then add customized columns.
(3) Append table 2 and table 3.
Best Regards,
Neeko Tang
If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.