Moving data within spreadsheet

Hello,
I am copying data from another system to an excel spreadsheet. I need to create a pivot table in the end. Data is very busy and when I Text to column some data is on the second line. I want to add a column and move one column of data to the newly created column. I will then sort the data, delete un-needed and create a pivot table for a monthly figure.