Google user
Original Poster
Oct 1, 2020
How do I move every other cell in a column to the right?
A
B
A
B
A
B
etc.
and would like to know how to reformat this into
A B
A B
A B
A B
A B
etc.
where A and B are in separate columns.
Details
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
All Replies (2)
Google user
Original Poster
Oct 1, 2020
Here's a formula that will generate such columns based on the column reference:
- ={filter(A:A,isodd(row(A:A)),row(A:A)<floor(rows(A:A),2)),filter(A:A,iseven(row(A:A)))}
There's no check for contiguous blanks, so the array is sized to half the number of rows in the sheet. I think it should be good enough since you'll probably be copying and pasting what you want as values.
Oct 1, 2020
You can try this too.
={filter(A1:A,isodd(row(A1:A))),filter(A1:A,iseven(row(A1:A)))}Best,
Prashanth KV
Last edited Oct 1, 2020