Multiple Splitting of rows

[QurrathAmeena]

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

[Qiu]

@QurrathAmeena 

Try to be dynamic

[RolandSchubert · Accepted solution]

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.

Let me know if it works for you.

Best,

Roland

[grazitti_sapna]

 Hi @QurrathAmeena,

Here is my solution to the problem.

If this is what you are looking for kindly like and mark this post as solution.

Thanks.

[QurrathAmeena]

Hi @RolandSchubert 

Thanks for Quick response,It worked!!