Concatenate 2 tables from 2 different tables

[gheecalipes25]

I would want to concatenate 2 columns from 2 different tables. example below:

Table A 

Table B

i would like to combine the Sequence Number (Table A) and Region Overall (Table B). What syntax would i need to do? sample output below.

[amitchandak · Accepted solution]

@gheecalipes25 , You need to merge these tables in the power query and then create a new column

: https://radacad.com/append-vs-merge-in-power-bi-and-power-query

or

You can copy one column value from one Table to another

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8