Copy data to another column Macros

Please see the excel files in attachment. I have a worksheet that has 2 lines in each cell. I would like to move the line below to another column.

For instance

Cell 1 data
teststest
54545

I need to move 54545 to another a new column on the same row.


I have attached the sample excel file and the sample_complete file (the needed results)

I believe I have to create a macro. I never done this before. Please help

Huan