Combine Data with Different Columns on Multiple Sheets into a Single Sheet

Hey,

I'm not sure what I do not understand.
These are the steps:

1 - Import both sheets into Power Query 

I imported both sheets from your sample xlsx that you provided. After that I have to queries in Power BI, please make sure that for both queries the 1st row has been "promoted" to column headers, if this is not the case use this step:

2 - Reorder the columns in of the tables manually (just drag and drop)

3 - Append one table to the other

Here you will find my pbix file. Please open Power Query and have a closer look at query "Sheet2".

Here are step 2 and 3 in more detail.

The red rectangle marks the step that have been executed/created by Power Query automatically during the import.

The green rectangle marks the steps that I added manually afterwards

1st additional step - Manually reordering the column by dragging and dropping

2nd additional step - Append query/table Sheet1 to query/table Sheet2.
This is the Append command that I'm referencing:

If, for whatever reason you want to append query/table "Sheet2" to query/table "Sheet1", just select query "Sheet1" and execute the Append command here.
Performancewise I recommend to append the smaller table (less rows) to the larger table (more rows). 

The final step (at least until now) creates the table in your latest post, except the reordering, but basically this is due to how the tables are appended.

Regards,

Tom