Split column with comma delimiter and uneven number of items

[Anonymous]

Hei!

I'm working with a dataset listing technical documents with unique numbers.  A list of reviewers is assigned to each document.  All reviewers are listed in *one field* named "Reviewers" and each name is split by comma.

Challenge: each document has a different number of reviewers.  If I split column by comma delimiter, I will end up with anywhere from 1 to 10 columns of names.

Goal: Count how many documents are assigned to each reviewer.

The dataset looks something like this

DocNo	DocTitle	Area	Reviewers
123-XYZ	Data Sheet	97	Person 1, Person 2, Person 3
456-ROP	Plot Plan	21	Person 2, Person 5
789-LMN	I/O List	72	Person 1, Person 2, Person 6, Person 7
012-SAT	Equipment List	21	Person 2, Person 6

Aim is to count how many documents Person 2 is responsible for reviewing at every weekly cut-off.

Thanks ever so much for your ideas!

Cheers.

[AllisonKennedy · Accepted solution]

See if this link will help. https://www.excel-university.com/split-delimited-list-into-rows/

[Anonymous]

Thanks, @AllisonKennedy   This seems like a great start!