I have a table that looks like this

Location ServiceDay

Farmingdale Monday
Farmingdale Tuesday
Bethpage Monday
Bethpage Saturday

I'd like to have a query that gives me one row for each location like this

Location Sunday Monday Tuesday Wednesday Thursday Friday Saturday
Farmingdale Yes Yes
Bethpage Yes Yes


I want yes or space to show in column relating to the service day
Any ideas?