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.
|