Forum Discussion
DarylRob
Helper I
Helper IUnpivot columns but create two value columns
Hi Chaps, I've got a table like below and I want to be able to unpivot it so it creates an "Hours" column and a "MRR" column but then only one row per quarter... Name Q1 Hours Q2 Hours ...
In power query:
1) Unpivot so you end up with:
Gary, Q1 Hours, 100
Gary, Q1 MRR, 10
etc....
2) Split the column with rows like Q1 Hours and Q1 MRR into two using either column from example or split column on deliminator (space). Ending up with:
Gary, Q1, Hours, 100
Gary, Q1, MRR, 10
etc....
3) You can then pivot to get Hours and MRR as column names.
bcdobbs
Community Champion
Community ChampionIn power query:
1) Unpivot so you end up with:
Gary, Q1 Hours, 100
Gary, Q1 MRR, 10
etc....
2) Split the column with rows like Q1 Hours and Q1 MRR into two using either column from example or split column on deliminator (space). Ending up with:
Gary, Q1, Hours, 100
Gary, Q1, MRR, 10
etc....
3) You can then pivot to get Hours and MRR as column names.