copying data one excel sheet to another with transposing columns Closed

Question

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.

TrowaD · Answer

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

Copying data one excel sheet to another with transposing columns

1 response

Similar discussions

Subscribe To Our Newsletter!