Power Query in Excel is a powerful tool designed to streamline the process of importing, cleaning, and transforming external data.

When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.

Figure A Transfer the Excel Table into Power Query. How to add a new column in Power Query Our goal is to combine the t-shirt sales by client into a single cell for each client.