My issue is complicated. I need to take data from a cell that has a space "cherry banana", and make it into two cells "cherry" and "banana". I want to duplicate my line on which the data resides, if possible.
What I have is a sheet like this:
IDs Data
1 banana
2 apple
3 cherry apple
4 cherry banana apple
5 apple
and I need to turn it into this:
IDs Data
1 banana
2 apple
3 cherry
3a apple
4 cherry
4a banana
4b apple
5 apple
Any idea how I can do this?
If not, then how do I simply parse out my data in a cell to other cells using the space as the delimiter?
Thanks,
Multi
Bookmarks