Make stacked columns into one row

Enter this in AH2 for part two of your problem. The rest of your problem I just don't understand.

Formula:

=IF(RIGHT(A2,1)=CHAR(47),O3,"")

This also works

Formula:

=IF(RIGHT(A2,1)="/",O3,"")

For numbers as the first character on the left this will work

Formula:

=IF(AND(LEFT(A2,1)>CHAR(47),LEFT(A2,1)<=CHAR(57)),O3,"")