Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
'Interleaf' columns of data
I need to take two large columns of data and 'interleaf' them. So, if I have data in columns A and B, I want in column C: C1 = A1 C2 = B1 C3 = A2 C4 = B2 C5 = A3 C6 = B3 C7 = A4 C8 = B4 etc. How can I do this? Thanks. -- Testing123 ------------------------------------------------------------------------ Testing123's Profile: http://www.excelforum.com/member.php...o&userid=16631 View this thread: http://www.excelforum.com/showthread...hreadid=490327 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
'Interleaf' columns of data
In C1: =OFFSET($A$1,(ROW()-1)/2,1-MOD(ROW(),2))
Autofill that down through column C. HTH. --Bruce "Testing123" wrote: I need to take two large columns of data and 'interleaf' them. So, if I have data in columns A and B, I want in column C: C1 = A1 C2 = B1 C3 = A2 C4 = B2 C5 = A3 C6 = B3 C7 = A4 C8 = B4 etc. How can I do this? Thanks. -- Testing123 ------------------------------------------------------------------------ Testing123's Profile: http://www.excelforum.com/member.php...o&userid=16631 View this thread: http://www.excelforum.com/showthread...hreadid=490327 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
'Interleaf' columns of data
For a non-volatile option, you can try this:
In C1, or *any* cell in any other column besides A or B, enter: =INDEX(A:A,(ROW(A1)+1)/2) AND, in the cell right *under* the first cell, enter: =INDEX(B:B,(ROW(A1)+1)/2) Then, select *both* cells and drag down to copy as needed. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Testing123" wrote in message ... I need to take two large columns of data and 'interleaf' them. So, if I have data in columns A and B, I want in column C: C1 = A1 C2 = B1 C3 = A2 C4 = B2 C5 = A3 C6 = B3 C7 = A4 C8 = B4 etc. How can I do this? Thanks. -- Testing123 ------------------------------------------------------------------------ Testing123's Profile: http://www.excelforum.com/member.php...o&userid=16631 View this thread: http://www.excelforum.com/showthread...hreadid=490327 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
how do I lookup data based on two columns of data | Excel Worksheet Functions | |||
Text to Columns / Importing Data | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) |