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