let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column2", type date}}),
#"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 0, 1),
#"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Added Index", {{"Column3", type text}}, "en-US"), List.Distinct(Table.TransformColumnTypes(#"Added Index", {{"Column3", type text}}, "en-US")[Column3]), "Column3", "Column1"),
#"Removed Columns" = Table.RemoveColumns(#"Pivoted Column",{"Column2", "Index"}),
#"Reordered Columns" = Table.ReorderColumns(#"Removed Columns",{"2019", "2020", "2021", "2022", "2023", "2028", "2027"}),
#"Replaced Value" = Table.ReplaceValue(#"Reordered Columns",null,"0",Replacer.ReplaceValue,{"2019", "2020", "2021", "2022", "2023", "2028", "2027"}),
#"Added Custom" = Table.AddColumn(#"Replaced Value", "Custom", each [2020] & [2021] & [2022]),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "Custom.1", each [2023] & [2028] &[2027]),
#"Replaced Value1" = Table.ReplaceValue(#"Added Custom1","0"," ",Replacer.ReplaceText,{"Custom", "Custom.1"}),
#"Renamed Columns" = Table.RenameColumns(#"Replaced Value1",{{"2019", "Before 2020"}}),
#"Removed Columns1" = Table.RemoveColumns(#"Renamed Columns",{"2020", "2021", "2022", "2023", "2028", "2027"}),
#"Renamed Columns1" = Table.RenameColumns(#"Removed Columns1",{{"Custom", "2020-2022"}, {"Custom.1", "After 2022"}}),
#"Replaced Value2" = Table.ReplaceValue(#"Renamed Columns1","0"," ",Replacer.ReplaceText,{"Before 2020"}),
#"Trimmed Text" = Table.TransformColumns(#"Replaced Value2",{{"2020-2022", Text.Trim, type text}, {"After 2022", Text.Trim, type text}})
in
#"Trimmed Text"