Hi all! I am unable to split row since it has multiple comma separated values.I would highly appreciate the help! This is the sample data : FruitPriceRegionapple,kiwi,orange10,20,30Abanana,watermelon,grapes30,40,50Bkiwi,grapes,guava15,25,20C The Output I'm trying to get is : FruitPriceRegionApple10Akiwi20Aorange30Abanana30Bwatermelon40Bgrapes50Bkiwi15Cgrapes25Cguava20C

Multiple Splitting of rows

Hi all!

I am unable to split row since it has multiple comma separated values.I would highly appreciate the help!

This is the sample data :

Fruit	Price	Region
apple,kiwi,orange	10,20,30	A
banana,watermelon,grapes	30,40,50	B
kiwi,grapes,guava	15,25,20	C

The Output I'm trying to get is :

Fruit	Price	Region
Apple	10	A
kiwi	20	A
orange	30	A
banana	30	B
watermelon	40	B
grapes	50	B
kiwi	15	C
grapes	25	C
guava	20	C

Preparation

Accepted answers

RolandSchubert

Hi @QurrathAmeena ,

I assume, the number of fruits in column [Fruit] is the same as the number of prices in column [Price]. A very simple solution could be to split column [Fruit] and column [Price] using different Text To Column tools, add an ID to each of the results and to re-join.