Formula for sorting information

[itshewe]

I want to know how to drag cells using the little square that you click on the right bottom of the cell. I want to auto fill formulas so that it takes information from A1, A4, A7... to C1, C2, C3.

Sheet1
a1=rat
a4=mouse
a7=cat
a10=horse
a13=monkey
a16=human

Now i want to write a formula in C1 so when i pull down the information below is listed in order..

Sheet1
C1 = rat
C2 = mouse
C3 = cat
C4 = horse
C5 = monkey
C6 = human


I don't want to use filter or delete empty cells. Could you please help.

Kind regards,
Hewe

 

[63falcondude]

How's this?

Excel 2010
	A	B
1	rat	rat
2		mouse
3		cat
4	mouse	horse
5		monkey
6		human
7	cat
8
9
10	horse
11
12
13	monkey
14
15
16	human
Sheet1

Cell Formulas
Range	Formula
B1	=OFFSET(A$1,ROWS(B$1:B1)*3-3,0)