Forum Discussion
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:
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"
6 Replies
- v-diye-msft
Community Support
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"thanks for your help
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
