Power Query - Transpose Multiple Rows into Single Column

[t0mato]

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!

[#2]

@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.

[#3]

@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.