Rearrange entries
I have a spreadsheet with 5 columns of data. The problem I am having that
column E contain multiple values in a single row seperated by a comma.
01/09,03/10,22/10
How can I extract the data so I have one entry per value? Basically, copy
the values in the first 4 columns and have the 1st value from column E,
insert a new line copy the values in the first 4 columns and have the 2nd
value from column E, copy the values in the first 4 columns and have the 3rd
value from column E, and so on based on the number of values contained in
column E.
Thank you,
QB
|