how to do this in excel with a pivot tabel Use Excel's PivotTable functionality to reorganize the data set so that the average number of clinic visits per weekday per week over this time period is displayed, and include a filter for year. i have the following columns: date, weekday, and visits