Reformatting Data In A Table Into Headers

I have a table with three headers:

Types: close to 4,000 total cells in the column with multiple repeats
Amounts: Obvious
Names: Only 6 available names (i.e. Tom, Bill, Fred, Richard, Sam, Alex)

It looks like this:

Type Amount Name
Type 1 | $$$$ | Tom
Type 1 | $$$$ | Bill
Type 2 | $$$$ | Fred
Type 3 | $$$$ | Richard
Type 3 | $$$$ | Tom
Type 3 | $$$$ | Sam
Type 3 | $$$$ | Alex
Type 4 | $$$$ | Fred

What I want to do is create a table with the parameters using the information contained in the previous table:

Type Tom Bill Fred Richard Sam Alex
Type 1 | $$$$ $$$$ $$$$ $$$$ $$$$ $$$$
Type 2 | $$$$ $$$$ $$$$ $$$$ $$$$ $$$$
Type 3 | $$$$ $$$$ $$$$ $$$$ $$$$ $$$$
Type 4 | $$$$ $$$$ $$$$ $$$$ $$$$ $$$$

Is there any way to convert the first table to the second table? I'm using Mac OS/X