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.
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.
- It worked for cells A1 and A2 but then it skips cell A3 and goes to A4. It skips every third cell.
1A
B3
4D
5EThe way you posted the sample data makes it difficult to know what they really look like.
Could you attach a sample workbook?
- 17-329X
V33897360X
2017-1072X
V92921408X
2017-1233X
V55931648X
17-1362X
V11924954X
17-329X V33897360X
2017-1072X V92921408X
2017-1233X V55931648X
17-1362X V11924954X