| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you interleave two columns
If you have two columns of data, what's the easiest way to automatically
(programatically?) interleave them. The resulting column should consist of: 1st cell of 1st column 1st cell of 2nd column 2nd cell of 1st column 2nd cell of 2nd column etc. For example, 1 a 2 b 3 c would become: 1 a 2 b 3 c |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i specify alternating cell range (de-interleave) in excel? | Excel Discussion (Misc queries) | |||
| to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
