Sounds like what we'd use a Summary report for...
I'm assuming each "chair" in your band is a separate record. If not, it should be.
Let's assume you have these fields:
Instrument, chair, name
Set up a list view layout based on this table.
Add a sub summary part to this layout "when sorted by Instrument".
Put the Instrument field in the sub summary part.
Put the name field and any other fields you want from this table in the body.
Sort your records by Instrument (can be an arbitrary order controlled by a custom value list), then by "chair" and you should get a list like this:
1st chair flute name
2nd chair flute name
1st chair clarinet
If you want a strict table format:
Flute 1st chair
Clarinet 1st chair
That can also be done with a conditional format expression and no sub summary part that uses getNthRecord to compare the value of Instrument with the previous record's instrument field and hides the contents of the field by changing the size to 500 if the values are equal.
Thank you, thank you, thank you! I have been trying to figure this out for a long time. Your solution worked like a charm!