Pivot Table with Unique Columns

Hello Excellers,

I am working on creating a pivot table where the data is being deprived from a database. More details are described below:

Deprived Data:
A:A is a list of names
B:B is a list of four different labels

Issue #1: B:B has UP to four different labels (Some could have 1, 2. 3 or all 4 labels and so on).
Issue #2: B:B would look like this Apple, Berry, Cabbage, Dragonfruit. I want to be separated in its own column (Text-to-Column??)
Issue #3: In the pivot table, I want the labels to have approriate labels in their own columns regardless of the number of labels each name has (i.e. All Apple should be located in the column of "Apple", all Berry should be located in the column of "Berry" and so on)

An example of the raw data:

Name Label(s)
V Apple, Berry, Cabbage
X Berry, Cabbage
Y Apple
Z Apple, Berry, Cabbage, Dragonfruit


The 'result' pivot table I would like to see is below:

Name Apple Berry Cabbage Dragonfruit
V ✓ ✓ ✓
X ✓ ✓
Y ✓
Z ✓ ✓ ✓ ✓


I have a feeling this is actually an easy thing to develop... But I lack the expertise to do so.

Help would be much appreciated!

Thanks!!!

Hi excellenthelp

First thanks for providing a chuckle - your typo makes me want to take the "p" out of you - but I will deprive myself of the opportunity.

I attach a solution that seems to work.

The pivot table headings was "Sum of Apple" etc. I tried to change that to "Apple" as per your request, but was not allowed to because that is already a header in the base data - so I used "Apples" instead.

Hope this meets your requirements.

Regards
Alastair

Aydeegee (Alastair),

Thanks!! The spreadsheet you shared with me works great. I am going to use it in my spreadsheet.

As for you, MarvinP- thank you for your contribute too!

Marking this as SOLVED.