Forum Discussion
Excel - Moving two columns of data into one column of data
I need to move two columns of data into one column of data. The second column needs each cell to go under the corresponding row cell next to it. Is this possible? See example below please.
1 a
2 b
3 c
4 d
1
a
2
b
3
c
4
d
Thanks, Jhall212
Let's say the data are in A1:B4.
In D1, enter the formula
=INDEX($A:$B,QUOTIENT(ROW()-1,2)+1,MOD(ROW()-1,2)+1)
and fill down.
9 Replies
Let's say the data are in A1:B4.
In D1, enter the formula
=INDEX($A:$B,QUOTIENT(ROW()-1,2)+1,MOD(ROW()-1,2)+1)
and fill down.
Thank you so much! Do you know how to move items from one column into two columns?
Example:
1
A
2
B
3
C
4
D
TO:
1 A
2 B
3 C
4 D
Thanks!
Jhall212
Let's assume that your data are in column A, starting in A1.
Enter the following formula in C1:
=INDEX($A:$A,3*ROW()-2)
And in D1:
=INDEX($A:$A,3*ROW()-1)
Select C1 and D1, then fill or copy down.
