VBA/Macro: Copying a cell for an indefinite number of cells.

[jrader]

So I have the following table (though much longer, thousands of rows), and I need to make it look like the second table. That means taking the number in P Type and paste it down in P Level until the next number in P Type, where I repeat the process, and so on (observe the difference between the two tables). A macro wouldn't work, or at least I wouldn't know how to make a macro work, and I've never used VBA. How exactly would I automate this? Thank you.

I have excel 2011 on mac.

Game	P Level	P Type
1		1
1		AA
1		AK
1		AS
1		SA
1		AA
1		SKA
1		2
1		AA
1		SK
1		A
1		SA
1		AK
2		1
2		AA
2		A
2		AK
2		SKA
2		2
2		AA
2		A
2		SKA
2		3
2		A
2		AA
3		1
3		A
3		2
3		AA

<tbody>
</tbody>

Game	P Level	P Type
1		1
1	1	AA
1	1	AK
1	1	AS
1	1	SA
1	1	AA
1	1	SKA
1		2
1	2	AA
1	2	SK
1	2	A
1	2	SA
1	2	AK
2		1
2	1	AA
2	1	A
2	1	AK
2	1	SKA
2		2
2	2	AA
2	2	A
2	2	SKA
2		3
2	3	A
2	3	AA
3		1
3	1	A
3		2
3	2	AA

<tbody>
</tbody>

 

[MickG]

Try this in "B3" and drag down

=IF(ISNUMBER(C2),C2,IF(ISNUMBER(C3),"",B2))

 

[jrader]

Try this in "B3" and drag down

=IF(ISNUMBER(C2),C2,IF(ISNUMBER(C3),"",B2))

That ended up doing the trick, except for a more complicated form:

=IF(ISNUMBER(D2221),D2221,IF(ISNUMBER(D2220),D2220,IF(ISNUMBER(D2219),D2219,IF(ISNUMBER(D2218),D2218,IF(ISNUMBER(D2218),D2218,IF(ISNUMBER(D2217),D2217,IF(ISNUMBER(D2216),D2216,IF(ISNUMBER(D2215),D2215,IF(ISNUMBER(D2214),D2214,IF(ISNUMBER(D2213),D2213,IF(ISNUMBER(D2212),D2212,IF(ISNUMBER(D2211),D2211,IF(ISNUMBER(D2210),D2210,IF(ISNUMBER(D2209),D2209,IF(ISNUMBER(D2208),D2208,IF(ISNUMBER(D2207),D2207,IF(ISNUMBER(D2206),D2206,IF(ISNUMBER(D2205),D2205,IF(ISNUMBER(D2204),D2204,IF(ISNUMBER(D2203),D2203,IF(ISNUMBER(D2202),D2202,IF(ISNUMBER(D2201),D2201,IF(ISNUMBER(D2200),D2200,IF(ISNUMBER(D2199),D2199,12345))))))))))))))))))))))))