Unanswered: Query table data into alternative format
If I have a single table with the following fields:
location, date, status, Value1, Value2, Value3, etc.
north Jun1 Y 3 2 2
north Jun1 N 1 1 3
south Jun1 Y 5 2 1
South Jun 1 N 2 1 0
North Jun7 Y 2 3 2
North Jun 7 N 1 1 1
How can I use SQL or code to pull records from this table into a query and/or another table into the following format: by location and by individual Value (numbers represent the count of the values by status each week-entries are made once a week)?