Nov 29 2021 09:43 PM - edited Nov 29 2021 09:44 PM
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:
As detailed, Requisition Number FULLT071366 has 4 rows of data, I would like these all listed for the same requisition, in a single line. Only the data regarding [Step], [# Candidates in Current Step] and [Average Days in Current Step] For example, like below:
Notice how each new row for the requisition is given its own column within the same row. How can I achieve this with Power Query?
I've attached the data here with the first row of data being an expected output.
Thanks in advance!
Nov 29 2021 10:05 PM - edited Nov 30 2021 12:01 AM
@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.
Nov 30 2021 03:32 PM
@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.