Copying data one excel sheet to another with transposing columns

[Closed]
Report
Posts
1
Registration date
Thursday November 12, 2015
Status
Member
Last seen
November 12, 2015
-
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
-
We have a spreadsheet with rows and rows of data.
Let's say column 1 is name, column 2 is address, column 3 is phone number, column 4 is rep name.
Let's say there are 50 rows of entry.
I need to move all 50 rows of data into sheet 2.
Let's say in sheet 2, column 1 is name, column 2 is phone number and column 3 is address, sheet 2 does not use column 4 from sheet 1, rep name.
I am getting the raw data from one source in sheet 1 and need to reformat it into the acceptable format to upload it into another source via sheet 2, so we are taking fields in sheet 1 and coping all of the data from the fields required by sheet 2 into sheet 2.
How do you do this? Thanks in advance.

1 reply

Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
Hi Sshyman,

So you are basically asking how to rearrange column, right?

Right-click the column letter of the column you want to move and select Cut.
Then right-click the column letter you want to move the cut column to and select Insert Cut Cells.

By the way, transposing is changing vertical data into horizontal data and vice versa.

Or I completely misunderstood you. What really helps is to show some sample data of how it looks now and how you would like it to look.

Best regards,
Trowa