The first formula 'skips' the even rows and puts values in the odd rows. The first formula can be pasted into E3 then copied over to F3, then while both those cells are still highlighted the fill handle of F3 may be dragged down as far as necessary. Note that there will come a point at which the formula will begin to return #VALUE because there are no more dates in column A.
The second formula puts values in the even rows (rows that the first formula leaves blank). The second formula may be pasted into G3 and dragged down as far as necessary. It will also eventually begin to return #VALUE when the data in column C runs out.
To eliminate the #VALUE displays you could wrap both formulas in the IFERROR function as in:Let us know if you have any questions.Formula:
=IFERROR(IF(ISODD(ROW()),INDEX(A$3:A$8,1+1*(ROW(1:1)-1)/2),""),"")
Bookmarks