October 1, 2019
Google Drive link is attached to demonstrate the type of data I am starting with. There are 2 tabs of desired results. I can't figure out what tool(s) I need to use to get from one point to the other. I'd prefer to not create a record for each day of an event (as some can last for months). But without a record for each, how to pivot it? And, if I did use a method that created (or generated) a record/date for each day, would the spreadsheet become to unwieldy as it grows. I'd like to be able to query the data for a date range, or an open ended range.
Guidance on where to begin is appreciated. Thanks.
November 8, 2013
You should use a pivot table, it's much easier to view and filter data. I used power query to add year, quarter, month and week before adding the pivot, but you can use formulas in additional columns of the data table.
The only other solution will be a custom code written for this specific case.