| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I fit columns A and B to column C with A on top of B?
Say you want to start your serialized data in cell AA2. Enter in AA2
the following formula (assuming data in A2:L101): =INDEX($A$2:$L$101,INT((ROW()-ROW($AA$2))/12),MOD(ROW()-ROW($AA$2), 12)) Copy down. HTH Kostis Vezerides On Jun 27, 5:21 pm, Emma wrote: I have 12 columns of data that I want go into one column; Column A is first, then Column B follows underneath, then Column C, etc. using Excel. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I turn excel columns from column number to column letter? | Setting up and Configuration of Excel | |||
| I have 3 columns of data. Column A has 900 items in it, Column B | Excel Discussion (Misc queries) | |||
| Sum of 2 columns * 3rd column | Excel Discussion (Misc queries) | |||
| 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) | |||
Threaded Mode
