Insert data in column, based on data in another column.

[JEM]

Hi, I hope some of you may be able to help me with a small problem I have encountered, and haven't found a way to solve so far.

As shown in the picture; 

My data currently looks like the upper example, and I am trying to turn it into the example below.

The accounting system puts the account number into the column as the date. I wish to separate the account number into a new column, as shown.

I have done this in Excel with VLOOKUP, however, as this is a recurring issue, I would prefer a flow in Alteryx.

I hope someone has an idea on how to perform this action, thank you!

 

[JEM]

Much appreciated! My life just got a little easier

[atcodedog05]

Happy to help : ) @JEM 

Cheers and have a nice day!