title: Can I get relational data into an Excel Pivot Table
body: <p>I have a sheet (let's go with wines as an example) that lists every bottle of wine in my cellar, when I bought it, how much I paid etc.</p>
  
  <p>There's a column that describes the wine in comma-separated tags such as "Fruity, White".</p>
  
  <p>I've created a pivot table from that data, with the description as a filter column. However I can't filter it by "White". I have to find every description that contains "White" such as "Dry, White", "White, Crisp" etc.</p>
  
  <p>Being from an RDBMS background, my natural inclination is to put the tags in their own table keyed against the wine row so there's zero-or-more tag rows per wine row.</p>
  
  <p>How, how on earth can I use that to filter the wine rows?</p>