Get Data from Nested Table and Concatenate Items using Power Query

A guide to getting data from a nested table, and combining items into one cell, using Power Query on Excel

Steps
1. Add a Custom Column
2. Type and modify this M Code inside the Custom column formula box:

=Text.Combine(Table.ToList( Table.SelectColumns([All], "Item")), "; ")

3. Change [All] to the name of your nested table. Change "Item" to the column you want to get from inside the nested table.

[Ali-dkrr]

Super useful and well presented. Thanks!

[Tattysnuc]

your explanations is clear and layered exactly as per my issue. thank you for sharing your wisdom via this video- it has helped me enormously.

[Rice]

That's what I've searched for!🙋
Thanks a bunch!🤗
Now i can move forward! 😁👌

[jankrzysztofrakowski]

Great video, thank you! Was stuck on this problem

[ggzhscg]

supper explanation. We can make do pivoting these results and create headers out of that.

[EmreErdogan]

Thank you very much. Been searching all over to figure this out. Even chatGPT and Bard :).
I'm using this in an outlook email query. I can now write multiple email attachment names to a cell, thanks to you.
Is there a way we can add a condition to this formula, like select the attachments.name column if the attachments.inline == false ?
To filter out the inline attachments, I have to
1. first extract the attachments column ( a table),
2. then filter out inline:true,
3. then group the table by "ID"
4. Then work your formula in this new grouped table.
5. Combine 2

If I could get a condition in there, maybe I could save extracting and regrouping.

[pepper_lab]

Please make more vdo
Please come back