Looking for a formula to pull certain values from one column and put into another column

Hi

Long story short, I have this large text document I am trying to parcel date from. I imported it into excel and I need a formula that will look at column A and only pull a certain value and populate into column B but keep repeating that value down the column until the formula gets to a new value I wanted in column A and switches to that value and continue. This would be the same scenario for Column C and D. I have an example of what I wanted to end up with. Thank you for any help the forum can provide

Sincerly TOM