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.

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.