@Quentin wrote:
Generally in this situation of super-wide tables the easiest way to decrease the amount of code you have to write is to restructure your data.
Currently it looks like you have one row per name, with variables category1-category100.
If you can transpose it to make your data have 100 rows per name, with three variables: name, categoryID (1-100), category, then your code should become much easier to write. And as an added bonus, when someone adds category101, you won't have to update your code.
All excellent points! Long beats wide!
... View more