View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Testing123
 
Posts: n/a
Default '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