Bring data from other table based on conditions

[Ancaaaa]

Hello,

I have these 2 tables, first called Targets and second DATA_Exit... i would like to bring in table DATA_Exit the targets specific to each metal status / Country.

Really appreciated your help here.

[FreemanZ]

hi @Ancaaaa 

you just need to unpivot the table in Power Query.

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Country"}, "Attribute", "Value"),
#"Renamed Columns" = Table.RenameColumns(#"Unpivoted Other Columns",{{"Value", "Targe"}})
in
#"Renamed Columns"