Transpose selected columns (rows) into multiple columns

[JWick1969]

Hello,

Searching for an answer for my requirements using power query but seem's i can't find the right code.

I'm trying to transpose a table with 15 columns (only selected column to be transpose stepid, failcode, faildesc, stepid2) and  create multiple columns. I'd like to group them by ID, route, itemid,  status.

I've tried table.transpose  and Pivot table but I'm not sucessful and also I dont think i have the correct values of fields added on the code.

This is my current table. using only a couple of columns as sample.

The second image is the expected result/output  after transpose.

 

Any help is very much appreciated.

Thank in Advance!

JW

[lbendlin]

Please don't do that. This is the antithesis to what Power BI is about.  

Instead, create a matrix visual and arrange your fields from your original table (which is fine as is) as needed.