In The List, Select Pivottable And Pivotchart Wizard, Click Add, And Then Click Ok.

How do i create a pivottable using multiple sources of data in excel? Check the box labeled “add this data to the data model” and press ok. On step 1 page of the wizard, click multiple consolidation ranges, and then click next.

Select The First Table You Want To Add To The Pivot Table.

Click “insert” at the top of the screen. Under choose commands from, select all commands. Check the boxes of the cells you wish to include.

Click The “Pivottable” Button On The Ribbon.

Click a blank cell (that is not part of a pivottable) in the workbook. On step 2a page of the wizard, click create a single.