Combine multipe tables

[frankhofmans]

hi all,

probably one of the most stupid questions :). I have three tables:

Table 1: Region 1

Sales ID	Region ID
S001	R010
S002	R011
S003	R012

Table 2: Region 2

Sales ID	Region ID
S001	R017
S002	R018
S007	R019

Table 3: Region 3

Sales ID	Region ID
S008	R020
S001	R021
S009	R022

I want to add one "total table"

Sales ID	Region ID
S001	R010
S002	R011
S003	R012
S001	R017
S002	R018
S007	R019
S008	R020
S001	R021
S009	R022

All tables have 100.000+ rows, but have a unique "Key" (sales ID & region ID).

Many thanks in advance

Regards, Frank

[Idrissshatila]

Hello @frankhofmans ,

You could acheive this using append queries in Power query.

check this for intrsuctions https://learn.microsoft.com/en-us/power-query/append-queries

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin