Power Query
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}}),
#"Extracted Year" = Table.TransformColumns(#"Changed Type",{{"Column1", Date.Year}}),
#"Replaced Value" = Table.ReplaceValue(#"Extracted Year","$","",Replacer.ReplaceText,{"Column3"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Replaced Value",{{"Column3", Int64.Type}}),
#"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Changed Type1", {{"Column1", type text}}, "lt-LT"), List.Distinct(Table.TransformColumnTypes(#"Changed Type1", {{"Column1", type text}}, "lt-LT")[Column1]), "Column1", "Column3", List.Sum)
in
#"Pivoted Column"
Bookmarks