Convert cell lists to columns with identifiers

[Anonymous]

I've got a table like so:

and I would like to convert the "labels" column from the list that exists to three new columns. Like the following:

closed_at	closed_by	dept	detection	priority	milestone	assignees
null	null	Platforms	Passive notification	High	null	List
null	null	Networks	null	Medium	null	List

Not all labels will exist in the cell, so I need to be able to skip and insert null if that doesn't exist. And i would like to remove the text before and including the "::" in the rows. I've been using PowerBI for maybe 12 hours so apologies if this is simple to do. Please let me know if any more information is useful

[amitchandak]

@Anonymous , on the label column, at the end there is expand sign those two angled arrow in in opposite direction, click on that and check what options you have. It should allow adding columns or rows.

For steps refer this video around json. but steps should be same

How to import JSON Data: https://youtu.be/MPYfEetvFH4

[Anonymous · Accepted solution]

Thanks, I think I was trying to do too many things in one operation. I ended up expanding the data, separating by semicolons, then splitting it out into columns in a separate step