Forum Discussion
t0mato
Nov 30, 2021Copper Contributor
Power Query - Transpose Multiple Rows into Single Column
Hello! I am working on tracking application data and have a large data set. I have multiple rows for the same Requisition that need to be housed within the same row. See example below: ...
Riny_van_Eekelen
Nov 30, 2021Platinum Contributor
t0mato I would consider a pivot table (see attached), Then you can easily line-up similar steps as well. Obviously, the first row (that you had already extended manually is not correct now.
t0mato
Nov 30, 2021Copper Contributor
Riny_van_Eekelen This is actually very useful and helpful. I think this works. I will look into this to make sure I understand how you did this.