If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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/ |
#2
|
|||
|
|||
Excel - How to mix columns
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/ |
#3
|
|||
|
|||
Excel - How to mix columns
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/ |
#4
|
|||
|
|||
Excel - How to mix columns
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/ |
#5
|
|||
|
|||
Excel - How to mix columns
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/ |
#6
|
|||
|
|||
Excel - How to mix columns
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/ |
#7
|
|||
|
|||
Excel - How to mix columns
You could try this formula in C1 & copy down.
=OFFSET($A$1,ROUNDDOWN((ROW()-1)/2,0),MOD(ROW()-1,2)) HTH, Andy |
Thread Tools | |
Display Modes | |
|
|