unique column value to rows

[SUDHIBEE]

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

[rubayatyasmin · Accepted 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.