I have several thousand lines of data describing a taxonomy.
Each layer in the taxonomy takes up 3 columns. So Layer 1 is A-C, Layer 2 is D-F etc. Currently the taxonomy is 11 layers deep (33 columns)
For each layer the first column is the index, the second is the name, the third is the long description
Each row includes all elements of the hierarchy for that entity.
Lines 1-50 might all have identical text in columns A-C: "1;birds;creatures that fly and have feathers"
Lines 2-20 might have identical text in columns D-F: "(a);small birds;creatures weighing less than 100g"
lines 3-10 might have identical text in columns G-I: "(i);migratory small birds;small birds that fly more than 100km on a seasonal basis"
and so on.
So Row 3 as a csv would read:
1,birds,creatures that fly and have feathers,(a),small birds,creatures weighing less than 100,(i),migratory small birds,small birds that fly more than 100km on a seasonal basis
I want to run a macro that groups all the Layer 1 rows ending at a change-in-index in column A, then groups all Layer 2 rows ending at a change-in-index in column D and so on for 10 layers.
It should first clear all current grouping
It should always leave 1 line visible and group the rest of that group, so the first row acts as the title to see what has been hidden beneath it