combine 2 workseets to create on pivot table

amy_baker

To create a pivot table from data on two different worksheets, you’ll first need to combine the data into a single table. One way to do this is to use a third worksheet to consolidate the data from the two original worksheets.

Here’s an example of how you can do this:

1. Create a new worksheet and give it a name such as “Combined Data”.
2. In the new worksheet, set up column headers that match the headers in your two original worksheets.
3. Copy the data from the first worksheet and paste it into the new worksheet below the headers.
4. Copy the data from the second worksheet and paste it below the data from the first worksheet.
5. Make sure that the data is properly aligned with the column headers.

Once you have combined the data into a single table, you can create a pivot table from it.

Here’s how:

1. Select any cell within the combined data table.
2. Click on the “Insert” tab in the ribbon and select “Pivot Table”.
3. In the “Create PivotTable” dialog box, make sure that “Select a table or range” is selected and that the “Table/Range” field shows the range of cells containing your combined data.
4. Choose where you want to place the pivot table (e.g., in a new worksheet) and click “OK”.
5. Use the PivotTable Fields pane to arrange your data as desired.

This should allow you to create a pivot table that includes data from both of your original worksheets.

Hope this helps you.