I have a delimina inwhich I'm trying to create a report, but the data is in one column but I'm trying to separate it out and put in another column.

The data looks like this:
Last Name Type Amount
Frog General $50
Frog Donation $75
Frog Payment $35


Desired Look
Last Name General Donation Payment
Frog $50 $75 $35

Is there a way to make this happen.