Extracting values of List of records by comparison to second list

[Anonymous]

My data is the following shape (sample): 

name	list_of_ids	properties
A	List	List
B	List	List
C	List	List

The lists in the column list_of_ids look like this (list of ids, not always the same amount) : 

List

4

7

9

3

And the lists in properties contain Records:

List

Record

Record

Record

Record

Record

Each of these Records looks like this:

id	5
name	language
value	en

or

id	4
name	language
value	de

or

id	1
name	age
value	36

My goal is a table where alll the various property names a new columns with empty cells in case there is no value:

name	language	age	level
A	en	55	beginner
B		60	beginner
C	de		advanced

Now to my problem: It might happen that for one person (lets say Person A), there are three different Records with information about "language", but with different ids. I only want to abstract the information of the record with an id which is in the list_of_ids for this person. I am still quite new to Power BI and would apprectiate your help very much 🙂 

[lbendlin]

Is your source data JSON or XML?  Can you post a sample?