Concatenating for pivot table

[Confuddled]

I have two words in one cell in the data table, for example "apple pear" which have been concatenated from previous cells (in some cases I might have up to 6 entries) but in the pivot it shows as 1 entry. I need apple & pear to be 2 single entries in the pivot table.
What can I put in the concatenate to make the pivot think it's 2 single entries?


Thank you

Claire