Formula to find header and insert in new column

Hi,

First post so sorry if I'm not that clear.

I'm hoping someone can help me with a formula I've been searching and found similar problems but not specific enough. I'm trying to find one of four potential headers in column B and insert it into a blank column A alongside each row it corresponds to. The report comes like this and I need to sort it before entering into a database.

It doesn't have to be that clean I can let the database do that, I just need to have the correct header in the new column.

I've attached what it looks like and what I'm trying to get, thanks in advance

DB

Hi

Definitely not clean but....

A3: =IF(ISNUMBER(B3),A2,B3)

HTH

rylo

that works great thanks a lot vlady