Excel - How to mix columns

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
GML


---
Message posted from http://www.ExcelForum.com/

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 **
"GML " wrote in message
...
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
GML


---
Message posted from http://www.ExcelForum.com/

Sorry. What I really need is:

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

TIA
GML


---
Message posted from http://www.ExcelForum.com/

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
GML


---
Message posted from http://www.ExcelForum.com/

Hi
enter the following in C1
=OFFSET($A$1,INT((ROW()-1)/2),MOD(ROW()-1,2))
and copy this down

--
Regards
Frank Kabel
Frankfurt, Germany


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
GML


---
Message posted from http://www.ExcelForum.com/

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

"GML " wrote in message
...
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
GML


---
Message posted from http://www.ExcelForum.com/

You could try this formula in C1 & copy down.

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

HTH,
Andy