I have a table with three columns.
The 1st has values of 1 or 0 that show if the option of the 2nd column is selected. The 2nd column is the name of the option. The 3rd indicates at what aspect this option belongs to, from predefined aspects. All these are defined.
The selected options (values of 1) I want to automatically report as a row of solutions, depending on the aspect that it belongs to.
For example, the name of the option with the value: 1, name: heat1 and aspect: heat would be reported in a table next to the aspect heat. If more options have the same aspect and have a value 1, they are reported at the cell next to the heat1.
Please, let me know how I could solve this, I have attached an excel file to help you understand what the result has to look like.
Décerné à :
I have been working on excel and database from past 2 years. I have a solution for this right now but on a safe side I have to put 1 day for this work.
7 freelance font une offre moyenne de €19 pour ce travail
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India