How to create a column with no blanks using data from a column with blanks

[Weekescl]

Hi all,

Really basic excel user here with help needed on something i'm sure you'll be able to do within seconds.

I have a column that has numbers in it generated from a formula. Some of the cells in the column have blanks as a result of returning " " when the the formula didn't match.

I want to create a formula in the column next to it that takes the cells with numbers only and puts them in consequtive cells and ignores the blank ones (basically, if it gets to a cell that is blank keep going until you find the next cell with a number in it and return that one).

Big thanks in advance!

 

[sheetspread]

Excel 2010
	A	B	C
1
2	84		84
3	66		66
4	19		19
5	43		43
6			39
7	39		73
8	73		4
9	4		70
10			14
11	70		73
12	14		74
13			33
14	73		3
15	74		94
16			13
17
18
19
20	33
21	3
22
23
24
25	94
26	13
Sheet3

Cell Formulas
Range	Formula
A6	=""
A10	=""
A13	=""
A16	=""
A17	=""
A18	=""
A19	=""
A22	=""
A23	=""
A24	=""
C2	{=INDEX($A$1:$A$26,SMALL(IF($A$2:$A$26<>"",ROW($A$2:$A$26)),ROW(A1)))}
Press CTRL+SHIFT+ENTER to enter array formulas.