I have an excel spreadsheet with 3 columns. The first column is merged downwards to be the length of the other cells and contains a document name. The other 2 columns contain an id and some text respectively.
The spreadsheet ultimately will contain extracts from about 100 documents and I would like to be able to filter by document to see the document specific rows, however when I try to set up filtering, I can only return the first row per document name.
Is there any other way to accomplish this task? I tried using grouping however I didn't really understand it.