Forum Discussion

laitung1991's avatar
laitung1991
Frequent Visitor
7 years ago
Solved

transfer columns to row from 2 table

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:
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    7 years ago

    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"

     

v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
7 years ago

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's avatar
laitung1991
Frequent Visitor
7 years ago

thanks for your help