Enter Power Query Copilot, a powerful AI-driven feature in Excel that’s here to transform how you work with data.

Let's imagine that you've found a table on Wikipedia that you want to transform using Power Query. To import the table, first, you clicked "Get Data" on the Home tab on the ribbon, and then ...

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.