Have a long list of index numbers each with one or more categories. Each category is listed in a new column next to the index numbers.

326, Logistics, Training, IT
329, Education, Software
333, Systems Integration

I'm trying to transpose the data to filter by category.

326, Logistics
326, Training
326, IT
329, Education
329, Software
333, Systems Integration

This isn't a direct transpose and the challenge is that each item has one or many categories. I'm sure it would take a macro to do this but I wouldn't have a clue how to begin. Need help! Have a long list and it will need to continuously be updated.