Fortunately, it isn’t difficult to transpose column values into a single cell as long as you don’t want to group the results. In that situation, you can use Microsoft Excel Power Query.

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

The Transpose feature allows you to rotate data from columns to rows and vice versa from rows to columns without reentering any of the data.

Learn how to create a risk assessment matrix in Excel with this step-by-step guide. Automate, visualize, and simplify risk management with a ...