Create table from Column

[PeterParker]

Hi all,

so. I have a table withe two colums, first column is a id , an the next a text.

I want to create a new table or list from there.

id1	text
1	[{"id":"de822d32-dcac-4fef-8886-023d2767a597","type":"scoring","value":"65","decimalValue":"65"},{"id":"60df1ef8-1cb6-4712-91d8-137dfb768bd1","type":"csat","value":"2","decimalValue":"2"},{"id":"2fa566f3-9713-4c1d-91a7-f33975980232","type":"scoring","value":"62.5","decimalValue":"62.5"},{"id":"8545ba70-4d95-4420-b70c-fc1fec1bdf15","type":"sentiment","value":"negative","decimalValue":"0.100000001490116"}]
2

i want create from the "text" column a table or a list.

For exampel:

Id1	test1	test2
1	id	de822d32-dcac-4fef-8886-023d2767a597
1	type	scoring
1	value	65
1	decimalValue	65
	id	2fa566f3-9713-4c1d-91a7-f33975980232

etc.

The next problem is, in the text column (first table) have diffrent length.

Thank for your help.

RG 

[HotChilli · Accepted solution]

at least 2 steps to perform in Power Query.

1. Split the column (by comma (at each occurrence) -> 'To Rows)

2. Split the resulting column (by colon) 

--

There will be some other tidying up required but that is most of it.