Forum Discussion
Solved
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 ...
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.
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