Copying data one excel sheet to another with transposing columns

Closed
sshyman
Posts
1
Registration date
Thursday November 12, 2015
Status
Member
Last seen
November 12, 2015
- Nov 12, 2015 at 03:37 PM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- Nov 16, 2015 at 11:46 AM
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

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
Nov 16, 2015 at 11:46 AM
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
0