Split dictionary values into columns

alpb 

You can do this in power query by 

1. remove {}

2. split column on ,

3. add an index row

4. unpivot all but the index row

5. remove the Attribut column

6. split the Value on :

7 pivot value.1 column showing value.2 without any aggregation.

I have attached my sample file for you to look at.  Just right click on the table and select "edit query" to see the steps.

Hi  alpb ,

unpivot all but the index row --> in this step, if I have other columns, let's say "name, job title", do I also include these 2 columns in the unpivot stage?

Yes.

could you please explain more about step 7? i am not sure how to do that. There is a pivot column functionality, but how do I choose to show value or do one without any aggregations?

Pivoting column Value.1 according on values from Value.2 using "not aggregated" based on index column:

Then you will get the result you need.

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!