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.
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