PowerQuery Array(List) and Object(Record) to Strings

[Zizasascha]

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:

Please Login or Register  to view this content.

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}

[JeteMc]

Hello Zizasascha and Welcome to Excel Forum.
Not to say that I can resolve the issue but it may be easier for someone to help if we could see a sample file. (See the "HOW TO ATTACH YOUR SAMPLE WORKBOOK" banner at the top of the page)
Also, is the only solution you want PQ or would a formula/VBA solution be acceptable?
Let us know if you have any questions.