combing three tables with same structure and combining total fields from each

Copper Contributor

My three tables have the same structure, but different data

I want to combine tables and calculate totals for each row.

 

1 Reply

Hi @qwbewinggmailcom 

There are several ways to do that, it depends on your data and what do you want to do.

You can use Data Consolidate, From Data menu --> on the Data Tools --> Consolidate

Then add the table ranges and specify where to put the new data.