Create a helper column DosID in column D with formula =A2&B2, dragged down
as required.
Create a pivot table on a new sheet with PetID as row, Medication as column,
Dosage as data.
Select all cells in pivot table sheet, Copy and PasteSpecial(Values) them in
a new sheet.
Delete unnecessary total row an column.
Enter this formula in cell B4 (at intersection of 0001 row and Anti-itch
column):
=INDEX(Sheet1!$C:$C,MATCH($A5&B$4,Sheet1!$D:$D,0))
Sheet1 being your original sheet.
Drag formula to the right and down as required.


Regards,
Stefi

€� ezt Ã*rta:

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