I'm having a bit of a "brain block: on this and hoping someone can give me some ideas. 

I have an Excel file built by Microsoft forms which allows multiple responses to some questions.  Each multiple selection question stores its response in its own cell with each selected item separated by a semicolon.  The form captures an unique product, 1 to many depts. who use the product (12 depts.) , 1 to many uses for the product (6 different uses) and 1 to many unacceptable outcomes of the product (6). 

What I'm planning to do is create unique table for each question using the product as a unique key.  Within each table, I want to create a separate row containing the product and a response.  For example, if the response to "How many depts. use this product?" contains 8 different depts. separated by semicolons, I want to create 8 unique rows for the dept. table.

I just can't seem to find a solution to parsing the answers and creating a unique product/dept row for each answer.  Any idea how this could be done? Or, on the other hand, am I completely off-base with this approach?  I need to be able extract how many depts. use a product [n] in what manner and who may be using it inappropriately.  

Thank you