How to create ... Launch Power Query Editor from the Get Data dropdown in the Get & Transform Data group. To add a blank query, right-click in the query panel (to the left) and choose New Query.

Create a new column in the Power Query editor to store the subheading values ... In the new column, use a formula or function to extract the subheading values from the source data.

Click the X in the upper right-hand corner to close the Power Query Editor. A window will open and ask if you want to keep your changes. Choose Keep. The workbook with our data will open in Excel, ...

Click on OK in the Create Table popup ... Close & Load button in the top-left corner of the Power Query Editor to export the data in a new Excel worksheet. That’s it! I hope you find this ...

we’ll load the data into Power Query. Then, we’ll add an index column, so you can visually see which products belong to the same order. Next, we’ll create the new rows using a delimiter query.