Need help inputting LARGE volumes of data

So I have a data that looks something like this:


6FTT57 Chris Turpin Jim Peterson Recon Plus 2012
6FUR2B Chris Turpin Surya Mantri MAS Prepayment Reporting Process
6G8KBZ Chris Turpin Julie Macauley MF-Portfolio Valuation Models 2011
6GFQQS Chris Turpin John Kim Debt and Dealer
6GFRJB Chris Turpin Surya Mantri CS/LTV Costing and Pricing System 9/1/2009
6GWJYM Chris Turpin Surya Mantri Error Tracking 5/1/2009
6JULMY Les Milner Don Southern DDAP (Summit & Eagle Sub-Ledger) Advantage
6JWPMC Chris Turpin Jim Peterson Recon Plus ETL 2012
6R2PDG Chris Turpin Jim Peterson WebMethods Flow Service - Ops Outsourcing


I need to put that into a bigger spreadsheet where for each ID (first column) found in the big spreadsheet, it has the value found in the other colums for its respective columns.

So I want something like:

WHERE ID = thisID,
Make colums A4, A5, A6 = to colums in thisSpreadsheet A4, A5, A6.

Thanks for your help!!!