let
Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
#"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "Column1", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Column1.1", "Column1.2", "Column1.3"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Column1.1", type text}, {"Column1.2", type text}, {"Column1.3", type text}}),
#"Split Column by Delimiter1" = Table.SplitColumn(#"Changed Type1", "Column1.2", Splitter.SplitTextByDelimiter("-", QuoteStyle.Csv), {"Column1.2.1", "Column1.2.2"}),
#"Changed Type2" = Table.TransformColumnTypes(#"Split Column by Delimiter1",{{"Column1.2.1", type date}, {"Column1.2.2", type text}}),
#"Split Column by Delimiter2" = Table.SplitColumn(#"Changed Type2", "Column1.2.2", Splitter.SplitTextByDelimiter("(", QuoteStyle.Csv), {"Column1.2.2.1", "Column1.2.2.2"}),
#"Changed Type3" = Table.TransformColumnTypes(#"Split Column by Delimiter2",{{"Column1.2.2.1", type date}, {"Column1.2.2.2", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type3",{"Column1.1", "Column1.2.2.2", "Column1.3"}),
#"Split Column by Delimiter3" = Table.SplitColumn(Table.TransformColumnTypes(#"Removed Columns", {{"Column1.2.1", type text}}, "en-US"), "Column1.2.1", Splitter.SplitTextByDelimiter("/", QuoteStyle.Csv), {"Column1.2.1.1", "Column1.2.1.2", "Column1.2.1.3"}),
#"Changed Type4" = Table.TransformColumnTypes(#"Split Column by Delimiter3",{{"Column1.2.1.1", Int64.Type}, {"Column1.2.1.2", Int64.Type}, {"Column1.2.1.3", Int64.Type}}),
#"Replaced Value" = Table.ReplaceValue(#"Changed Type4",1939,2019,Replacer.ReplaceValue,{"Column1.2.1.3"}),
#"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(#"Replaced Value", {{"Column1.2.1.1", type text}, {"Column1.2.1.2", type text}, {"Column1.2.1.3", type text}}, "en-US"),{"Column1.2.1.1", "Column1.2.1.2", "Column1.2.1.3"},Combiner.CombineTextByDelimiter("/", QuoteStyle.None),"Merged"),
#"Changed Type5" = Table.TransformColumnTypes(#"Merged Columns",{{"Merged", type date}})
in
#"Changed Type5"