title: excel pivot table - multiple columns
body: <p>I'm trying to create a pivot table in Excel using the following data:</p>
  
  <p><img src="https://i.stack.imgur.com/lyIw3.png" alt=""></p>
  
  <p>The end result I'm trying to come up with (using the pivot) is a summary like this:</p>
  
  <p><img src="https://i.stack.imgur.com/dOV4N.png" alt=""></p>
  
  <p>However I can't figure out how to get Excel to count / add / consider all columns.  I can create a pivot for each individual field/column, but can't figure out how to compile the data together.</p>