Ask Your Question
0

rearrange columns 'in between' method

asked 2016-11-15 10:53:54 +0200

LUCASPACE gravatar image

Hi folks! i'm having an headache with this problem: i have 2 columns (A,B) with equal lenght in rows (100000 each !!!). I want to re-arrange cells from A1, B1 A2, B2 A3, B3 and so on..

TO A1, B1, A2, B2, and so on..

How can i do that??

edit retag flag offensive close merge delete

Comments

...from A1, B1 A2, B2 A3, B3 and so on..
TO A1, B1, A2, B2, and so on. (??)

This looks pretty much the same. What should actually happen?
Would you mind to post a few rows of sample data in the given arrangement and in the wanted as well?
BTW: If columns A and B contain data of different semantical classes, simply drop the idea. The "every other row" arrangement would cause trouble again and again. "PtrettyPrint" is the only exception.

Lupp gravatar imageLupp ( 2016-11-15 11:46:45 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2016-11-15 12:32:42 +0200

karolus gravatar image

hallo
Maybe something like (in C1)

=INDEX($A$1:$B$100000;ROUNDUP(ROW()/2;0);2-MOD(ROW();2))

fill down to C50000

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-11-15 10:53:54 +0200

Seen: 51 times

Last updated: Nov 15 '16