Copying data one excel sheet to another with transposing columns

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.