Tough One! Trying to pull data out of columns seperated by commas.
I have a HUGE spreadsheet of cross reference information.
One column SOMETIMES contains several "model numbers" - not just one.
I'd like to be able to RIP OUT the data between commas in that column and
make a new row for just that one piece of data and then put all of the same
data from the columns back around the data... Hard to describe. Here is a
simplified example of what we are trying to do.
red....tree, bush, shrub, grass....money....car
blue..bike.................................cat.... .....truck
tan...apple, pear.......................dog........plane
Id like it to look like this:
red...tree.................................money.. ...car
red...bush................................money... ..car
red...shrub...............................money... ..car
red...grass...............................money... ..car
blue..bike.................................cat.... ......truck
tan...apple................................dog.... .....plane
tan...pear.................................dog.... .....plane
That is what we are trying to do!
Thanks for your help
|