Creating columns based on information in cell

**hswartz12** · 06-14-2023, 09:03 AM

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

**AliGW** · 06-14-2023, 09:06 AM

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.