'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 |
'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 |
'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 |
All times are GMT +1. The time now is 01:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com