The excel files I'm working with have multiple tables on one sheet separated by empty rows or in some cases empty columns. I'm having trouble separating these tables and adding them to Tableau. I have multiple sheets with multiple tables. I also have multiple excel workbooks for each year.
Sometimes I have 7-8 tables each below the other.I want to add each distinct table into tableau and compare the data in one table in one excel workbook by another table in another excel workbook by year.
