Forum Discussion
combing three tables with same structure and combining total fields from each
My three tables have the same structure, but different data I want to combine tables and calculate totals for each row.
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.