Merge multiple sheets with similar structure in a single table from Excel Workbook

Hi cgkas ,

We could achieve your desired output in Query editor, but that should be a little complex.

Please follow the steps. I will show the table 8873 as an example.

1. Assuming that you load the data in Query editor like below.

2. Remove the first row and duplicate the table

3. Remove the columns for the two tables and then append queries.

4. Add a custom column with the formula below.

#"Changed Type"[Column1]{0}

5. Please do the same modification for the other two tables and then Append the three tables.

Here is the final output.

For the detail steps, you could refer to the applied steps in Query Editor from my attachment.

Best  Regards,

Cherry