Ask Your Question
0

rearrange columns 'in between' method [closed]

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

LUCASPACE gravatar image

updated 2020-07-22 08:00:54 +0200

Alex Kemp 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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-07-22 08:01:09.475399

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

Question Tools

1 follower

Stats

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

Seen: 77 times

Last updated: Nov 15 '16