Return Multiple Items into Comma Separated Values with One Lookup Value

If you wanted to do a lookup and bring back multiple values, most likely it would put each of the values into a separate row. But what if you wanted to have those values in the same row but separated by commas. You might need to copy,paste and then do some concatenation of the values. This would be okay if it were a small table but if it was a larger table(s) or something you'd do on a recurring basis, it would be tedious. With Power Query, you can have this" auto-magically" done. It will involve some M function, but not that many. See how... P.S. Feel free to provide a comment or share it with a friend! #excel #msexcel #excel #msexcelandtricks #exceltutorial #doughexcel #excel101 --------------------- Excel Training: https://www.exceltraining101.com/p/training.html Excel Books: https://www.amazon.com/shop/dough #excel #msexcel #doughexcel