B1 has =INDEX($A:$A,(ROWS($1:1)-1)*14+COLUMNS($A:B)-1)
C1 has =INDEX($A:$A,(ROWS($1:1)-1)*14+COLUMNS($A:C)-1)
and each one is taking 2 cells, so the first is taking B1 and B2, the next
C1 and C2

Lisa


"Mikeopolo" wrote:


Can you please "cut/post" the formula you have in B1?

Many thanks
Mike


--
Mikeopolo
------------------------------------------------------------------------
Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570
View this thread: http://www.excelforum.com/showthread...hreadid=571352