I have a problem to solve, but i cannot figure it out how.

As you can see in the picture below in Row A i have numbers: 1, 2, 3 ... The goal is to link each of them in another row, but after each cell which contains a number there should be an empty cell.

Click image for larger version. 

Name:	excel1.jpg 
Views:	5 
Size:	91.4 KB 
ID:	1510

If i manually link first cells (C1=A1, C3=A2, C5=A3 etc.) and then mark them and extend the pattern it seems that pattern is broken (cell C9 should be =A5 instead of =A9).

Click image for larger version. 

Name:	excel2.jpg 
Views:	6 
Size:	93.1 KB 
ID:	1511

I hope i described my problem well that you can understand it and can help me.

Thank you alot!