Data Pivot help

[SonaSinghA]

Helo experts,
Need to pivot data like below
Please help

No	Name	Type
100, 101, 102	Apple	Fruit
200, 201, 202	Onion	Veg

No	Name	Type
100	Apple	Fruit
101	Apple	Fruit
102	Apple	Fruit
200	Onion	Veg
201	Onion	Veg
202	Onion	Veg

[Daniel29195 · Accepted solution]

Hello @SonaSinghA 

do the following : 

step1 :  select the column to expand to rows and click on spit columns -->  by delimiter,

step 2 : 

hit enter. 

f my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution !✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[SonaSinghA]

Missed advanced options. Thanks

[zenisekd]

Hi, judging by your data, you should first split the first column by the ", " in order to create separate columns with numbers. Next you can play with pivot/unpivot columns/other columns. 

Kudos and mark as solution appreciated 🙂