Forum Discussion

laitung1991's avatar
laitung1991
Frequent Visitor
6 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
    6 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"

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

So, Edit Queries is the way forward.

 

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

laitung1991's avatar
laitung1991
Frequent Visitor
6 years ago

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