Creating columns based on information in cell

Hello! I am looking at how to create sperate columns based on data all in one cell. I don't mean just splitting the cells, but taking all the data in a column (e.g. row 1 has oranges and row 2 has bananas) and creating a category for each product in the first row (hopefully the pictures will help). After this is done, I could then have excel output a 'yes' or 'no' (1 or 0) contingent on whether or not this was contained in the row. Thank you!


Data I have

Data.png

Result I would want to get

Result .png

Something like this formula... copy across and down;

=--ISNUMBER(SEARCH(B$8,$B2))

See attached.