presence/absence data from adjacent row

my problem is likely easily resolved, but i've tried several methods and haven't solved it myself.
here it is: i need to fill an adjacent row with either a "p" (or a 1) or an "a" (or 2, etc.), based on whether or not there is a value (a number) in an adjacent row.

thanks for any help,

Rick