Aug 06 2021 07:46 AM
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
Aug 06 2021 08:39 AM
SolutionLet'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.
Aug 06 2021 11:28 AM
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
Aug 06 2021 12:06 PM
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.
Aug 06 2021 12:25 PM
Aug 06 2021 12:45 PM
The way you posted the sample data makes it difficult to know what they really look like.
Could you attach a sample workbook?
Aug 06 2021 12:52 PM
Aug 06 2021 01:37 PM
I'm afraid that doesn't help.
Aug 06 2021 01:47 PM
Aug 06 2021 01:59 PM
Aug 06 2021 08:39 AM
SolutionLet'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.