Forum Discussion
Solved
unique column value to rows
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 |
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.
1 Reply
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.