p45cal Well-Known Member Jan 12, 2022 #26 Would pivot table do? I added a column (M) to the source data called Sub Header which is a concatenation of the first three columns. I created a pivot table on sheet2 which you can filter using these Sub Headers. Attachments Chandoo41222medicinal-complaints-by-species.xlsx Chandoo41222medicinal-complaints-by-species.xlsx 406.5 KB · Views: 5
Would pivot table do? I added a column (M) to the source data called Sub Header which is a concatenation of the first three columns. I created a pivot table on sheet2 which you can filter using these Sub Headers.
