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

%3CLINGO-SUB%20id%3D%22lingo-sub-3372635%22%20slang%3D%22en-US%22%3Ecombing%20three%20tables%20with%20same%20structure%20and%20combining%20total%20fields%20from%20each%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3372635%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20three%20tables%20have%20the%20same%20structure%2C%20but%20different%20data%3C%2FP%3E%3CP%3EI%20want%20to%20combine%20tables%20and%20calculate%20totals%20for%20each%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3372635%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3373107%22%20slang%3D%22en-US%22%3ERe%3A%20combing%20three%20tables%20with%20same%20structure%20and%20combining%20total%20fields%20from%20each%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3373107%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1389802%22%20target%3D%22_blank%22%3E%40qwbewinggmailcom%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20several%20ways%20to%20do%20that%2C%20it%20depends%20on%20your%20data%20and%20what%20do%20you%20want%20to%20do.%3C%2FP%3E%3CP%3EYou%20can%20use%20Data%20Consolidate%2C%20From%20%3CSTRONG%3EData%3C%2FSTRONG%3E%20menu%20--%26gt%3B%20on%20the%20%3CSTRONG%3EData%20Tools%3C%2FSTRONG%3E%20--%26gt%3B%20%3CSTRONG%3EConsolidate%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EThen%20add%20the%20table%20ranges%20and%20specify%20where%20to%20put%20the%20new%20data.%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.