Changing three columns of data in to a table in Excel 2007

Hi have basically have a very large spreadsheet that looks something like this:
Number Type Data
A b c
B s x
C r c
D f x

and i wanted to make it with the number for the rows, the type for the columns, and the data populating the spreadsheet. I could sort of get it to work using a pivot table but it would not show the actual data in the sheet just sum or count or whatever. Is it possible to do this?

Thanks