View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Question Boy Question Boy is offline
external usenet poster
 
Posts: 25
Default 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