Hello,
I am working on a large set of data with large number of rows. The data has company name and the product categories they manufacture. Their are 4 product categories. Every company can have more than 1 categories. The categories are in a single cell separated by commas. How can i create a table with all the companies in rows and all the 4 product categories in columns and having "YES" or "NO" wherever the categories are available.
Please find attached the sheet for a sample data and the the results to be achieved.
Thank you in advance.
Best regards,
Bookmarks