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 |
Solved! Go to 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
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.
Hi @RolandSchubert
Thanks for Quick response,It worked!!