Expand List and match field to show data

[jtp64]

I have a table expanded that has an embedded list.  The list contains records. Unfortunately, because the lists are applied to each row, it causes the row to be duplicated. So I need to be able to extract the list into columns and somehow get rid of the duplicate rows.  There are now unique keys for each row.

There are three records, key, namespace and value.  I want to be able to expand the list, but create new columns based on each "key", then populate that column with the data in the corresponding value field.  For example, row 1 has list with records of key=account_string, namespace=null (I don't need namespace) and value=45. row 2 may have key=company, value=ab.  I would end up with

account_string      company

     45                       ab

Hope that make sense.  Thanks in advance.

[YukiK]

You can apply "Remove duplicate" on multiple columns (Ctrl + click to choose multiple columns). And then I'd just add an index column or custom column like you mentioned where the column will be mix of your key columns.

Hope that makes sense!

[jtp64]

Thanks.  My bigger issue is getting the "list" expanded and converted into columns. That is where I am struggling.  I have looked at list.transform, etc but have not had good luck yet.