Using a mapping table to replace multiple values in multiple columns

Hi Anonymous 

In Edit queries,

  In Table 1

  1.Click on "Person" column, Unpivot other columns, then get columns: "Person", "Attribute","Value"

  2.Merge queries in Table 1, expand "old" and "new" columns from the queries.

   3. add a conditional column

  4.remove columns: "Value", "Table2.Old", "Table2.New"

  5. Ctrl+select "Attribute" and "Custom" columns, Pivot columns

Finally

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.