How to create pivot table from set with repeat data, blank cells

Attached is a sample of the data set I am working with.

I am trying to figure out how to create a pivot table so I can easily filter and see numbers like:

-How many dogs vs cats were adopted
-Who adopted the most number pets
-Which city had most number of pets up for adoption
-Of those, how many they were adopted

My questions are:
1. How do I arrange the data I have in a way where I could create such a pivot table?
2. What is the best way to organize columns and rows?

I have looked up step by step tutorials, but I feel dumb because I can't figure it out.

Urgently have to figure this out by Monday...

The trick with Pivot Tables is to make sure column fields are unique TYPES of stuff not unique values.

Play around with the attached. Remember you can drag and drop fields around the Field List window todice and slice the informtion in different ways.
I've also added some Slicers which allows you to quickly filter stuff.