Moving and inserting new values using a macro

Hello,
In the attached spreadsheet on 'Raw Data' tab, I have a few Customer Names in column A. The challenge is the same column also has different contracts numbers we have a with a customer.

Is is possible to write a macro that will move all the numbers from column A to column B and then will fill up column A with the respective customer names. You'll find an example of such output on 'Requested Output' tab.

Very much appreciate your help in advance,
Regards