No one has signed up yet this year.

LongNameEventSRAName MembersGuestsTotals

To make an Excel pivot table from Web table output

  1. Select only the table part.
  2. Copy the selection (Command or Control c).
  3. Open Excel and get a blank worksheet.
  4. Paste Special in cell A1 as TEXT NOT HTML.
  5. Select all numbers and convert to number format (if needed)
  6. Select All (Command or Control a).
  7. (Data -> Summarize with Pivot Table.)
  8. Newer version - Insert - Pivot Table
  9. Move Event->Column, SRAName->, Mem->Values
  10. Select and right click on cell with number in it.
  11. Pivot Table Options
  12. Replace empty cells to 0.
  13. OK
  14. Select All
  15. All Borders