split columns with with multiple spaces between fields

I would split by delimiter "=", then Text.Trim the whole table to remove any leading or trailing spaces. I would then add an index column and move it all the way left. Then you should be able to use the Pivot function in the GUI to pivot the columns. 
--Nate

This also can be done.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8kvMTbVV8MrPyFNwyU9VcEksSbU1MjAy1DXSNVZwTEkpSi0utlXwSy1XiMwvylaK1YFpCU7MxafDObOk0lYhILEos1gpNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Split Column by Delimiter" = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByAnyDelimiter({"Name= "," Date=", " Address= "}, QuoteStyle.Csv), {"Column1","Name", "Date", "City"}),
    #"Removed Columns" = Table.RemoveColumns(#"Split Column by Delimiter",{"Column1"}),
    #"Replaced Value" = Table.ReplaceValue(#"Removed Columns","City= ","",Replacer.ReplaceText,{"City"})
in
    #"Replaced Value"

it was actually trickier than it seemed! Here you are.

Spilt those fields! 

--Nate

Hi Anonymous ,

Please check the attachment.

The workaround is to Split columns by delimiter.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.