Splitting fields from commas

I'm not sure if this belongs here or in the Functions forum, so please just redirect me if I've erred!

I've got a sizable list of occupational categories (Legal, Government, etc.), however many fields contain more than one:

Occupation
Accounting
Accounting
Accounting, Government
Administrative
Administrative, Government, Legal
Administrative, Legal


I need to create subsequent columns, Occupation2 , Occupation3 , etc., and somehow split the fields in the Occupation column at the commas, and distribute the words horizontally into the next columns. I'm completely stumped, can anyone here help? Thanks!

DC