I am trying to create a formula that will look at a list of values arranged
and create list based on those value

Table of values input would look like the following:
A B C
1 Customer Plant Product
2 Publix Greenville Lemon
3 Food Lion Greenville Apple
4 Publix Spartanburg Apple
5 Food Lion Spartanburg Apple
6 BiLo Spartanburg Orange
7 Ingles Spartanburg Apple
8 BiLo Spartanburg Apple
9 Publix Spartanburg Orange
10 Publix Charlotte Lemon

Output I am hoping for:

1 Plants Affected
2 Publix Greenville, Spartanburg, Charlotte
3 Food Lion Greenville, Spartanburg
4
5 Products Affected
6 Publix Lemon, Apple, Orange
7 Food Lion Apple


You would enter the value in column A and the list in column be would
automatically be creating from the values in the table above {without
duplicates}