Hi,
I want to change Lists and Recors to Strings in PQ.

I am receiving data from an API and I have an Array and an Object Column like this:

let
    soure_tmp = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wio7JiykBQTgDCJUSk5JjlHSQRVJSgSIwgVgdrLoKgQBJEYQRq6SjVB2Tp6AQo5SWWVRcEp+XmJsao2QF5HvlZ+SBrQFJ5iSiyAXnZpZkwCUzi+MTczLLwHIlRaWpUOHEdLCIkXmtUmwsAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ArrayCol = _t, ObjecCol = _t]),
    #"Convert" = Table.TransformColumnTypes(soure_tmp,{{"ArrayCol", type text}, {"ObjecCol", type text}}),
    #"SoureAPI" = Table.TransformColumns(#"Convert",{{"ArrayCol", Json.Document}, {"ObjecCol", Json.Document}})
in
    #"SoureAPI"
Please note that the Step "Convert" is just for this example. I have to work with the Step "SourceAPI".

If I load them now to a normal ExcelSheet they look like this:
ArrayCol ObjecCol[List] [Record]


But I need them
ArrayCol
[[
"abc",
"dec"
],
[
"qqqq"
]
]


ObjecCol
{
"first_name": "John",
"last_name": "Smith",
"is_alive": true,
"age": 27}