Check the following article on Cross Tabs: http://www.sqlservercentral.com/articles/T-SQL/63681/

WITH SampleData (PERSON, [DATA], [FIELD]) AS

(

SELECT 1234,'04/02/2014','Date'

UNION ALL SELECT 1234,'123','Department'

UNION ALL SELECT 1234,'80.0','Rate'

)

SELECT PERSON,

MAX( CASE WHEN FIELD = 'Date' THEN DATA END) AS [Date],

MAX( CASE WHEN FIELD = 'Department' THEN DATA END) AS Department,

MAX( CASE WHEN FIELD = 'Rate' THEN DATA END) AS Rate

FROM SampleData

GROUP BY PERSON;