Ask Your Question

rearrange columns 'in between' method

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

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


...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 +0100 )edit

1 Answer

Sort by » oldest newest most voted

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

karolus gravatar image

Maybe something like (in C1)


fill down to C50000

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 41 times

Last updated: Nov 15 '16