Create new rows from pivot columns retaining category and value fields

[mcameron2909]

Hi all,

I have a requirement where we are importing list data from Sharepoint that has employee names as columns and this needs to be transformed to row values in our Power BI model to enable filtering and display.

Is it possible to process this with power query to achieve the following

Source table

Transform name columns to rows, retaining Category and Skill, repeated on additional rows created for each name

Transformed table

This is different to a straight table pivot in that some columns are pivoted, and some are kept as columns, with new rows created

This appears similar to the question and solution discussed here and response provided by @Greg_Deckler 

https://community.powerbi.com/t5/Desktop/Transpose-table-column-values/m-p/184083

however this doesn't appear to work with creating the additional rows required and retaining the Category and Skills values in the transformation above.

Many thanks for anyone who can assist!

Thanks,

Michael

[mahoneypat · Accepted solution]

Just select your Category and Skill columns, right click and choose "Unpivot Other Columns" to get your result.

Pat

[mcameron2909]

Thanks so much Pat, basic functionality that I've missed! Works as expected, cheers.