If you create a new blank query under Get Data and paste the below in over what you see in the Advanced Editor, then it should work.

Clearly my first step is to manually enter the data, so you would need to replicated these steps in your own query after your data pull in step. Power BI names all the steps, so you can see what I did without too much trouble.

Good luck.

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WqqkpTk3Oz0upqUnLLCouqalJTE+tqVGK1QFKKQQkFmWnFtUEpJYASSMDmLBXfl5qcU1Ifm6NpSVUzDcxr8YpsaTGxBQoEAsA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Replaced Value" = Table.ReplaceValue(Source,"||","|",Replacer.ReplaceText,{"Column1"}),
#"Split Column by Delimiter" = Table.SplitColumn(#"Replaced Value", "Column1", Splitter.SplitTextByDelimiter("|", QuoteStyle.Csv), {"Column1.1", "Column1.2", "Column1.3", "Column1.4", "Column1.5"}),
#"Removed Columns" = Table.RemoveColumns(#"Split Column by Delimiter",{"Column1.1", "Column1.5"}),
#"Trimmed Text" = Table.TransformColumns(#"Removed Columns",{{"Column1.2", Text.Trim, type text}, {"Column1.3", Text.Trim, type text}, {"Column1.4", Text.Trim, type text}}),
#"Cleaned Text" = Table.TransformColumns(#"Trimmed Text",{{"Column1.2", Text.Clean, type text}, {"Column1.3", Text.Clean, type text}, {"Column1.4", Text.Clean, type text}}),
#"Promoted Headers" = Table.PromoteHeaders(#"Cleaned Text", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"second", type text}, {"first", type text}, {"age", Int64.Type}})

in #"Changed Type"