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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - 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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
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