Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rearrange date | Excel Discussion (Misc queries) | |||
Rearrange columns using VBA | Excel Programming | |||
rearrange text | Excel Worksheet Functions | |||
rearrange data | Excel Discussion (Misc queries) | |||
Rearrange a formula | Charts and Charting in Excel |