Excel Magic Trick 1422

Power Query M Code: Join all Items From Invoice into One Cell

DESCRIPTION

Learn how to use the Power Query user interface and type M Code to quickly take all the items from an invoice and list them in a cell with a delimiter. The Data is in a Proper Data Table Format and we want to group all invoice items together in a single cell.

WORKBOOKS

Download “Excel Magic Trick 1421 1426.zip” Excel-Magic-Trick-1421-1426.zip – Downloaded 36 times – 1 MB







Be the first to comment

Leave a Reply