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.


[TABLE="width: 500"]
<tbody>[TR]
[TD]Game[/TD]
[TD]P Level[/TD]
[TD]P Type[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]AA[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]AK[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]AS[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]SA[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]AA[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]SKA[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]AA[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]SK[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]SA[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]AK[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]AA[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]AK[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]SKA[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]AA[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]SKA[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]AA[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]AA[/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="width: 500"]
<tbody>[TR]
[TD]Game[/TD]
[TD]P Level[/TD]
[TD]P Type[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]AA[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]AK[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]AS[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]SA[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]AA[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]SKA[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]AA[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]SK[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]SA[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]AK[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]AA[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]AK[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]SKA[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]AA[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]SKA[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]3[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]3[/TD]
[TD]AA[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]AA
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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))))))))))))))))))))))))