Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Column has multiple values, if any mutliple value comes in column; i want to convert all that multiple value of the columns to one row. Please help.
that is example
U PAX | DEPT | RANK | |
A | PERFUMES | 1 | |
A | BOOKS | 2 | |
B | COSMETICS | 1 | |
B | LIQUOR | 2 | |
B | PHARMACY | 3 | |
C | FOOD PLUS | 1 | |
D | ELECTRONICS | 1 | |
RANK | 1 | 2 | 3 |
A | BOOKS | PERFUMES | |
B | COSMETICS | LIQUOR | PHARMACY |
C | FOOD PLUS | ||
D | ELECTRONICS |
Solved! Go to Solution.
Hi, @SUDHIBEE
1. Open power query editor.
2. transform >> pivot column
3. pivot on DEPT column and expand the advanced options and select don't aggregate.
you will get your desired result. I did this. below is the ss.
rename the first column as rank.
Proud to be a Super User!
Hi, @SUDHIBEE
1. Open power query editor.
2. transform >> pivot column
3. pivot on DEPT column and expand the advanced options and select don't aggregate.
you will get your desired result. I did this. below is the ss.
rename the first column as rank.
Proud to be a Super User!