Forum Discussion
Moving contents of every other row up a row and one column to the right
I have a large table where the data was incorrectly stored. I need to move the data from the even rows up one row and to the right one column and then delete the empty rows. Is there a way to do this...
If you're looking to do this:
You could use:
=WRAPROWS(vector,2)
If you need this:
Then go with this:
=LET(
r, ROWS(vector),
seq, SEQUENCE(r / 2, , 1, 2),
INDEX(vector, seq) & " " & INDEX(vector, seq + 1)
)