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.

Step 3: Transform the Data in the Power Query Editor Before you load the appended data back into your Excel workbook, make any necessary adjustments to the data's structure.