Expand table fields value with multiple rows

[Arthurle2000]

Hello !

I have an issue on my table User with a colunm "Languages" which contain tables. Here 1 row = 1 user

Each table can contain 0-4 rows, 1 row = 1 language 

I only need the lookupValue column to get every language for each user but i don't know how to exploit it. If i expand the column i only have 1 column with the first row of each table...

[Arthurle2000]

Hi !

Thank you for your reply, it works well but i would like to have 4 columns ( 1 for each language ) instead of having multiples rows for each user. Is that possible ?

[v-jingzhang · Accepted solution]

Hi @Arthurle2000 

It's possible. First add a custom column with Table.Column([Languages],"lookupValue")

Then expand above custom column and select "Extract Values...". Select a delimiter per your need. 

Finally split above column with the delimiter you selected. 

 Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Arthurle2000]

Thank you very much, it works perfectly

[v-jingzhang]

Hi @Arthurle2000 

How did you expand the table column? You may try the following operation to expand it. Is the final result what you want? 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Powerbiasks]

Hello, if I want to spand a table and there are spaces that have more than 1 value, it duplicates the ID in order to spand it. I want that if have more than one it separetes with a coma.

For example: 

For example the ID 201 that have more than one user it creates more than one line for the same ID

I need that in this cases the 2 mails keept in one line separed by a comma