transfer columns to row from 2 table

[laitung1991]

I have 2 table : table1, table 2 and i want to take columns of table1 transfer row table2 and have new table3, i have picture for example:

[v-diye-msft · Accepted solution]

Hi @laitung1991 

Did you try the append queries?

let
    Source = Table.Combine({#"Table (2)", Table}),
    #"Replaced Value" = Table.ReplaceValue(Source,null,"Y/N",Replacer.ReplaceValue,{"Status"})
in
    #"Replaced Value"

[laitung1991]

thanks for your help

[Anonymous]

2 options...

you can use 'Merge Queries' in Edit Queries to join the 2 data sources.

Or

create a relationship between the 2 tables and then build a table/matrix visual using data from both tables.

[laitung1991]

i want to create new table not  build table/matrix visual, i tried Merge Queries but when join not enough record  for example when when join table 2 from table 1 have one record not two

thank you for your help

[Anonymous]

So, Edit Queries is the way forward.

Are you able to share a dashboard? or some screen shots?

[laitung1991]

i can't share file dashboard because my company don' want