Multiple tables in Power Query Editor Excel

[sumanthhc08]

Hi,

I am trying to consolidate multiple sheets into another workbook and I am seeing multiple tables.

Please find the below image and help.

How to remove duplicate tables?

[JoeBarry]

Hi @sumanthhc08 

What you are seeing there are Sheets (Those with the names) and their corresponding tables. I always import the tables only. When you load them in, you have append all the tables together. Home > Append tables. Untick enable load on the tables you imported and use the new Appended table in the report. (Do not delete these tables afterwards, otherwise the Append will fail)

Thanks

Joe

If this post helps, then please Accept it as the solution