Note -- this is one of three threads with the following titles:
• What is a pivot table? (Excel)
• What are the main purposes or benefits of pivot tables? (Excel)
• What are some scenarios in which pivot tables are most useful? (Excel)
I am a bit embarrassed to admit this but despite having used Excel for many years and having come across references to pivot tables on numerous occasions, I really don't know what they are or anything about them. Nevertheless, the frequency with which I see them mentioned suggests that they are a valuable tool and worth knowing how to use. For that reason, I would appreciate any comments that answer the following question:
• What are some scenarios in which pivot tables are most useful?