Excel - How to mix columns

  • Thread starter Thread starter GML
  • Start date Start date
G

GML

I need to mix some columns like this:
Suppose A1:A3 = 1,2,3 and B1:B3 = a,b,c
How can I get C1:C6 = 1,a,2,b,3,c ?
Is it possible just with formulae (no macro) ?
Any help would be appreciated
TIA
GM
 
try this in C1 =A1&","&A2

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Thank you, Paul
But, sorry, what I really need is: given columns A and B, get column C
(Dots only for formatting)

. . Given . . Get
. . . A . B . . C
1 . 1 . a . . 1
2 . 2 . b . . a
3 . 3 . c . . 2
4 .. . . . .. . b
5 ... . . . . . 3
6 .. . . . .. . c

TIA
GM
 
Hi
enter the following in C1
=OFFSET($A$1,INT((ROW()-1)/2),MOD(ROW()-1,2))
and copy this down
 
That is pretty easy to do using a sorting trick
Put B after A

1
2
3
and so on
a
b
c
and do on


now in an adjacent column put

1
2
3

after the numbers are done and adjacent to the letters use

1.5
2.5
3.5
and so on

copy down as long as needed so the adjacent help column looks like

1
2
3
1.5
2.5
3.5

now select both columns and sort ascending on the help column


--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
You could try this formula in C1 & copy down.

=OFFSET($A$1,ROUNDDOWN((ROW()-1)/2,0),MOD(ROW()-1,2))

HTH,
Andy
 
Back
Top