Hi,

I need help... :((

So, I've consolidated data from multiple sheets using the Append query to create a dashboard with a drop-down menu filter function. I renamed the appended data to "SitesConsolidated" and transformed it into a table.

While the tables are successfully stacked, I'm encountering an issue during data validation and filtering on the dashboard sheet. The appended data duplicates the rows when I refreshed the Power Query, causing confusion in the filter function.

Could you please help me resolve this duplication issue?

Thank you!

for context, it looks like this in my append table:

==

Content.Name 

TABLE1

TABLE2

TABLE3

SitesConsolidated

SitesConsolidated

SitesConsolidated

==

I am getting frustrated at this point