Hi everyone,

I'm hoping someone can help me...here goes. I have a spreadsheet
similar to this (this is obviously a sample but similar to the real
thing):

PetID Medication Dosage
0001 Anti-itch 10mg
0001 IV Bag 1000mg
0001 Vitamin shot 200mg
0002 Anti-itch 20mg
0002 IV Bag 6000mg
0002 Vitamin shot 100mg

Note that the petIDs are repeated because one pet can have many
dedication at any dosage.

I'd like the spreadsheet to look like this:

PetID Anti-inch IV Bag Vitamin Shot
0001 10mg 1000mg 200mg
0002 20mg 600mg 100mg

Any way to do this easily? I have over 600 records and the thought of
manually doing this nauseates me!

Thanks in advance.
TCM