Splitting Rows in Power Query

[LiamReidy]

Hello Power Bi Community

My team fills out an MS forms every month, scoring how they feel on categories (value, ownership, workload etc). The categories appear as their own column heading. However, i want to split this out so that rather than have separate column headings for "value", "ownership", "workload", i have a column heading called "Category" with possible values of "value", "ownership", "workload". Any help would be appreicated. See pic for what the dataset currently looks like.

[LiamReidy · Accepted solution]

Hi Greg, See pic below for what I'm trying to achieve. left table is what i currently have. right table is what im trying to get to. 

[Greg_Deckler]

@LiamReidy So are you saying that you want columns like 5, 4, 3, 2, 1 and that in those columns the row values would be "value", "ownership", "workload"?

[LiamReidy · Accepted solution]

Hi Greg, See pic below for what I'm trying to achieve. left table is what i currently have. right table is what im trying to get to. 

[Greg_Deckler · Accepted solution]

@LiamReidy Oh, you just need to select your three columns and unpivot them. Use Ctrl to select your three columns then right-click one of the selected columns and choose Unpivot.

[LiamReidy]

Thanks Greg!