Moving data within spreadsheet

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Text to column as far as I know splits a column into multiple columns and does not add rows. Some sample data would have helped to understand the issue. Could you post some at some share site like https://authentification.site and post link here