Excel Magic Trick 1415

Power Query Lookup and Return Multiple Items And Join Them In Single Cell

DESCRIPTION

See how to use Power Query to Lookup and Return Multiple Items And Join Them In Single Cell. Learn how to Group by Rows and use the Text.Combine Function. Learn how to use the Table.Group Function. Learn about the M Code behind the scenes when you use Power Query.
Topics:
(00:15) Introduction to problem and how we think about it in Power Query Using the Grouping Feature.
(01:36) User Interface Method
(05:36) Learn about M Code and Power Query Functions
(10:15) Type M Code Method

WORKBOOKS

Download “Excel Magic Trick 1411-1415” Excel-Magic-Trick-1411-1415.zip – Downloaded 69 times – 4 MB







Be the first to comment

Leave a Reply