Forum Discussion
Anonymous
3 years agoNot applicable
Counting same values in different columns
Hello everyone! This is my first question here. My problem is as it follows. I have my data from an excel archive and I have 4 columns that have pre defined values to assign to them. I want to ...
- 3 years ago
Anonymous
you can try in pq, select first three columns and unpivot other coluns
Unpivot columns (Power Query) (microsoft.com)
Then it will be easier for you to do the calculation
ryan_mayu
3 years agoSuper User
Anonymous
you can try in pq, select first three columns and unpivot other coluns
Unpivot columns (Power Query) (microsoft.com)
Then it will be easier for you to do the calculation