You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.

Learn how to handle column name changes in Power Query and prevent workflow failures with expert tips and dynamic solutions.

In that situation, you can use Microsoft Excel Power Query. In this tutorial, I’ll show you how to use Microsoft Excel Power Query to combine values into a single cell, within groups.