I have a large table of data and I need to create sub-tables that have the same columns, but a subset of the data based upon whether a certain value appears in the first column.
In the supplied workbook I have created some sample data. I would like to create subtables for based on the value in column A.
E.g. I would like a sub-table with all the rows where the value in column A is '9T'.
Bookmarks