Change pivot table format and count

Hello,

I would like to have a pivot table that will count the number of responses I get for a certain question

For example on the attached book I would like it to look something like:

a
blue 1
red 1
yellow 1
green 1
aa
green 2
yellow 1

and so on, I am sure this is possible just not sure how to make it happen. Any help is appreciated.

Thank you!