When an Excel data source (other than a cube) is already formatted as a cross-tabulation or is otherwise aggregated, options for viewing, aggregating, and grouping in Tableau are limited. Tableau cannot see underlying data points that have already been summarized into a higher-level group or order. To take advantage of Tableau’s full functionality, you need to normalize the data before connecting to it from Tableau.
You can normalize a table manually
