Forum Discussion
campelliann
Post Patron
4 years agoPivoting "not working" in PowerQuery
So basically I am Pivoting a column called "budget type". That then transforms into "Margem" "Revenue" Custo (3 last columns). The issue is that this only works if Projecto and subproject Rows ar...
- 4 years ago
You can try removing the column before the pivot. Technically you are unpivoting by the way.
Rows to Column = Unpivot
Column to Rows = Pivot
campelliann
Post Patron
4 years agoHi there nvprasad ajbogle, is there away to do the Pivot only based on column Project (ignoring SubProject).
ajbogle
Helper I
4 years agoYou can try removing the column before the pivot. Technically you are unpivoting by the way.
Rows to Column = Unpivot
Column to Rows = Pivot