Move data from one table into another table

[Anonymous]

Hi

Trying to combine the data in two tables into one, so I can sort in it.

Table1

Table2

For each GUID entry there is several Description rows. Each table contains data from the same GUID's.

I'm aiming at getting these listed in one table, so it's easier to sort based on Description and values.

Should look something like this

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may simply use Append Queries (Table.Combine) in Query Editor.