Convert Fields To Rows

I have a table (Not my own, cannot be changed) that has this structure:

Table1
ID, field, data
-----------------------
1, fname, john
1, lname, doe
1, address, 123 any st
2, fname, jack
2, lname, sprat
2 address, 345 some st
2, phone, 321-555-1234

I want this:

Table2
ID, fname, lname, address, phone
--------------------------------------------------
1, john, doe, 123 any st,,
2, jack, sprat, 345 some st, 321-555-1234

Notes:
This query will need to run on a regular schedule.
There are over 100 fields, I don't want to do this 100 times:


--UPDATE table2

--SET fname = table1.data
--FROM table2 INNER JOIN

-- table1 ON tablw2.ID = table1.ID

--WHERE table.field = fname



Any Ideas.