How to analyze survey text data - multiple answers can be selected

Hi,
I have a survey where the users can have multiple text entries. I get these answers in one column, but I want to to separate out all of these answers:
Name department study IDs
Name 1 Department 1 2022-0234;2314-0123;2022-1090
Name 1 Department 1 123-4567;3456-1234;2020-1090; only included 3
Name 3 Department 3 2020-0472;2020-0444;2023-0999
Name 3 Department 3
Name 4 Department 3 2022-0111;2023-0444;2019-0333
Name 4 Department 6 2024-2024
name 5 Department 7 2019-0001;nci0923434;alliance000111

Now, the outcome of analysis should look like:

Name 1 Department1

2022-0234
2314-0123
2022-1090
Name 3 Department 3
2020-0472
2020-0444
2023-0999
Name 4 Department 3
2022-0111
2023-0444
2019-0333

And so forth....

Names in one column/departments in another column, and all the values associated with the department column are placed in the column.

Could someone help me how to achieve this goal?
I do appreciate your help.

Only 1 thread per Q is allowed. Thread closed.