Can someone explain pivot tables like I'm 5?

I am not a data person and I can follow step-by-step instructions, but I cannot figure out how to get a certain type of answer when left to my own devices.