Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I combine multiple columns of data into 1 column?
I am trying to combine x number of columns into one single column.
Column B would begin in cell immediately at end of column A, Column C then wold begin immediately at end of now column A and Column B etc. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I combine multiple columns of data into 1 column?
Cut and paste.
If you want a formula: (each column should have the same number of entries otherwise you get 0's) .......A.....B.....C 1....1......2.....3 2....1......2.....3 3....1......2.....3 4.................... Enter this formula in A4 and copy down until you get 0's: =OFFSET(B$1,MOD(ROWS(A$1:A1)-1,3),INT((ROWS(A$1:A1)-1)/3)) In the formula, the 3's refer to the max number of entries in the columns. Here's what you'll end up with: .......A.....B.....C 1....1......2.....3 2....1......2.....3 3....1......2.....3 4....2 5....2 6....2 7....3 8....3 9....3 10..0 11..0 12..0 Biff "Frank" wrote in message ... I am trying to combine x number of columns into one single column. Column B would begin in cell immediately at end of column A, Column C then wold begin immediately at end of now column A and Column B etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
combining multiple rows of data into one single row of data | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
How to combine data from two columns into one column? | Excel Worksheet Functions | |||
merge data from multiple columns to single column | Excel Worksheet Functions |