Power Query: add column to combine Excel sheet and then expand list but see duplicated table

[Anonymous]

Hi Experts

I have a query with 2 spreadsheet as its data source.

After locating the files, I add custom column (with coding below) to combine the sheets out of them.

= Table.AddColumn(#"Filtered Rows2", "Custom", each Excel.Workbook([Content],null)[Data])

Then I got screenshot below.

Then I expand the list, then here comes the problem: the sheets are (more than) doubled... There are total 4 sheets in these 2 files, but I can see 9 expanded. The calculated result also demonstrates this finding. There is no hidden sheet. No idea how to solve this.

Thanks.

[AllisonKennedy · Accepted solution]

@Anonymous Sheets aren't the only object you can import from Excel. Do you have any tables or other data in the sheets? 

If you click in the white space next to the word table in your second screenshot above, you'll get a preview of what information is in each table so that might give you a hint where it's coming from.

[Anonymous]

Thanks Allison. Inspired by your suggestion I tried to check the hidden content of the spreadsheets in the PQ, and found there do exist couple of invisible stuff and removed them.

Now it's ok.