INSERT INTO Contacts (primary_key, fname, lname, phone)
SELECT primary_key,
MAX(CASE WHEN field_type = 'fname' THEN field_value END),
MAX(CASE WHEN field_type = 'lname' THEN field_value END),
MAX(CASE WHEN field_type = 'phone' THEN field_value END)
FROM foo
GROUP BY primary_key

--
David Portas
SQL Server MVP
--