Split Column A to multiple Columns, but Headers of each new column is within the values of Column A

[khacwee]

Dear all,

I have a table looks like below and I am trying to split Column A into mulitple new columns.

However, split by delimiter will not work since the values of all new columns will contain Header name (eg. order_id) within it. 

I have tried all the split functions in power query and the closest is to split by comma but all the values will still contain header name.

Please help !

Thanks in advance.

[collinsg]

Good day khacwee,

Your column A looks like JSON format. On the "Transform" ribbon of Power Query, the "Text Column" contains a "Parse" button. Clicking the drop-down arrow beside "Parse" offers "JSON" as an option. Choosing this will turn column A into a column of records. You can then expand column A to get the result you desire.

Hope this helps

[slorin · Accepted solution]

Hi

Select "Column A"  / Transform / Parse/ JSON

Expand Record

= Table.TransformColumns(Prev_Step,{{"Column A", Json.Document}})

Stéphane