I need help with adding multiple users to multiple groups.  The caveat is that my source data has one group name per row with the corresponding members in the same row.

Example Dataset  (Notice user names are separated by semicolon)

GroupName Members

Group1 Doe, Jane;Doe, John;Jordan, Jake;Chirba, Brian

Group2 Doe, John;Jordan, Jake

Group3 Doe, Jane;Chirba, Brian

Group4 Doe, John;Chirba, Brian

Three questions:

1. What import option will I use to achieve this?

2. What will my CSV column headers be?

I might be able to get my source data in this format, but it will take some heavy excel changes to achieve this

SamAccountName GroupName

Doe, Jane                   Group1, Group3, Group4

Doe, John                   Group2, Group4

Jordan, Jake           Group1, Group2, Group3, Group4

Chirba, Brian           Group1, Group3