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.
(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