Creating Pivot Table from multiple tables

[agmoreno1230]

I am trying to create a pivot table from two separate table columns on two separate worksheets in the same workbook. After I use Alt D, P, then complete the process, I get an error message that says I need to select two rows. Can anyone help with this?

 

[Jerry Sullivan]

Hi and Welcome to MrExcel,

You can't directly use non-contiguous ranges as a data source for PivotTables.

Alternatives include:
1. Combine the two table columns into a contiguous range on a worksheet using formulas.

2. Use a query to join the two columns and use the result of the query as the PivotTable's data source.