How to do it…

  1. Upon opening Tableau, from the Connect pane on the left-hand side, choose Microsoft Excel:

  1. When the Open window opens, navigate to your local copy of Bread_basket_by_year.xlsx, select it, and click Open.
  2. On the Data Source page, two tables contained within our data source, 2017 and 2018, appear. Beneath them, we see the New Union option:

  1. Drag and drop New Union onto the canvas.
  2. A new Union window will open. Drag and drop 2017 from Sheets into the Union window as well, as shown in the following screenshot:

  1. Click on Apply and then on OK to exit the Union window.