Seasonal Tip: Pivot Tables

In this tip, we use Pivot Tables in Google Sheets to create a Thanksgiving shopping list.

Here's a summary of the steps in the video:

  1. Create columns for Amounts, Ingredients, and Recipe Name.
  2. Fill in the ingredients for all of your recipes, making sure that whatever is in the Ingredients column is standardized (for example, don't put tbsp butter in one row and sticks of butter in another).
  3. Go to Data > Pivot Table.
  4. For the Rows, add your Ingredient.
  5. For the Values, add your Amount.
  6. If you'd like to remove one or more recipes, you can do so with the Filter feature.

Have a great break, and have fun in the kitchen!

Written by sobodda@brown.edu on