How do I summarize my data in a spreadsheet? How to summarize data from large data set Use a a pitovt table - see article here