Seperate Mixed Data from one column to multiple columns (organized)

I am looking to separate data that is being output in a single column. I can do this with formulas but would rather find a VBA solution that will allow me to separate the data. The attached shows a before and after for the report. There are 3 different metrics within the single column. A user ID, a Date and a Job Name in which they worked. The report exports by default with these 3 stacked and 2 empty columns. I would like to leave the User ID in column A, move the Job to B and the Date to C. Once this happens I would want the rows that the job and date started on to be removed as they are summary and/or empty rows. Let me know if you have questions after looking at the attached -

Cheers -

Edit - There will be an empty row above each Job updated in this attachment --->Example_DataSortVBA_.xlsx