I have a spreadsheet:
It has columns A - Z
In Column Z, I have a list separated by commas.
For example: bird, dog, cat, goat, etc
Each list in column Z may contain a different number of items in the list (some hold 2 some may hold 5 or more)
Desired Output:
In Column Z - At each comma, add it to column z, as a value on the row below and copy all of the data from the related column.
For Example:
bird
dog
cat
goat
and then copy the related data down.
Thanks for your help.
It has columns A - Z
In Column Z, I have a list separated by commas.
For example: bird, dog, cat, goat, etc
Each list in column Z may contain a different number of items in the list (some hold 2 some may hold 5 or more)
Desired Output:
In Column Z - At each comma, add it to column z, as a value on the row below and copy all of the data from the related column.
For Example:
bird
dog
cat
goat
and then copy the related data down.
Thanks for your help.