Listing incident categories
The usual design is to relocate each column with repeating values into its own table.

You don't say, but I'll call your current table Incidents, and I'll assume the Id is the primary key.

Next create a table for each repeating-value column and link them back to Incidents. For example

IncidentCategories1
  IncidentId
  CategoryID


Values will be (45, 10), (45, 28), (46, 2), (46, 22) etc. Similarly with IncidentCategories2. Reps column becomes

IncidentReps
  IncidentId
  RepName


with values (45, person1), (45, person2) etc. And and so on for the other columns with repeating values.

As for your question about whether it is worth it, well, that's quite subjective. You are using a relational database. The assumption is data is normalised. Your current design isn't. It makes sense to give the tool what it expects to receive, unless there are overwhelming reasons to do otherwise. The only one I can think of is that you only ever treat those repeating groups as a whole and never parse them (in SQL). In that case they can be considered strings that just happen to have commas at certain positions. For this your current design is fine.