- Remove filter views, and add filters to your sheet.
- Insert a new sheet and name it “Shirt Sales by Type.”
- Filter Shirt 1 by size, and record the number of shirts purchased in that size.
- Copy the table and paste it into your new sheet.
- Add a border, colors, and other formatting to your table.
- Repeat those steps for the rest of the sizes and shirts purchased.