Here is the code
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type any}, {"Column4", type any}, {"Column5", type any}}),
#"Transposed Table" = Table.Transpose(#"Changed Type"),
#"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(#"Transposed Table", {{"Column2", type text}}, "en-CA"),{"Column1", "Column2"},Combiner.CombineTextByDelimiter("|", QuoteStyle.None),"Merged"),
#"Transposed Table1" = Table.Transpose(#"Merged Columns"),
#"Changed Type1" = Table.TransformColumnTypes(#"Transposed Table1",{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}}),
#"Replaced Value" = Table.ReplaceValue(#"Changed Type1","VALUE|","",Replacer.ReplaceText,{"Column1", "Column2", "Column3", "Column4", "Column5"}),
#"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","|","",Replacer.ReplaceText,{"Column1", "Column2", "Column3", "Column4", "Column5"}),
#"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1","NA","0",Replacer.ReplaceText,{"Column3", "Column4", "Column5"}),
#"Promoted Headers" = Table.PromoteHeaders(#"Replaced Value2", [PromoteAllScalars=true]),
#"Changed Type2" = Table.TransformColumnTypes(#"Promoted Headers",{{"1990", type number}, {"1991", type number}, {"1992", type number}}),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type2", {"VAR", "ISO"}, "Attribute", "Value"),
#"Renamed Columns" = Table.RenameColumns(#"Unpivoted Other Columns",{{"Attribute", "Year"}})
in
#"Renamed Columns"
and here is where to find it
https://www.screencast.com/t/yIQ44R7TeO
Knock 'em Dead Tiger!