Is there a way to extract a unique list of names from say column C. Each row in the column C contains multiple names separated by commas.
Column C
bob jones, sam spade, tim good
john holmes, bad daddy, roy rogers
bob jones, flash gordon, tim good
results in:
bob jones
sam spade
tim good
john holmes
bad daddy
roy rogers
flash gordon
Column C
bob jones, sam spade, tim good
john holmes, bad daddy, roy rogers
bob jones, flash gordon, tim good
results in:
bob jones
sam spade
tim good
john holmes
bad daddy
roy rogers
flash gordon