D
David B
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 an
example.
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
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 an
example.
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