What are some good ways to create pivot tables when your source data is
in a table format, not a list format?

For example, how would you create a pivot table from a calendar, which
only has days' names at the top of the table, and has numerical dates
in each cell (ie a Regular calendar :)

The standard way would be to create a list of numerical dates, then add
a column and type in "Monday" for each date that is a Monday, "Tuesday"
for each Tuesday, etc.

---
Message posted from http://www.ExcelForum.com/