En cours

Excel work. Conditional selection of data and transposing them from column to row.

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.

Compétences : Saisie de Données, Traitement de Données, Programmation de bases de données, Excel

Voir plus : work values, offline excel data work, mis data work excel, excel data array conditional, image excel data work, data work excel sheet, excel data work, excel address column row, orgnize column row excel

Concernant l'employeur :
( 6 commentaires ) Eindhoven, Netherlands

N° du projet : #8544247

Décerné à :

vdhingra065

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.

12 € EUR en 1 jour
(0 Commentaires)
0.0

7 freelance ont fait une offre moyenne de 19 € pour ce travail

khushh07

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

28 € EUR en 1 jour
(89 Commentaires)
6.1
watersev

Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene

13 € EUR en 1 jour
(83 Commentaires)
5.3
farr4u

Hi, expert here ready to start.. pls .... I assure you high quality work done.... thanks and regards.............

27 € EUR en 1 jour
(31 Commentaires)
4.3
rathiyugal

I am expert in data entry and data processing.I have done HTML and WordPress websites and blogs.I have also experienced in Microsoft words, Excel, PowerPoint, sending emails, copy and paste, excel spreadsheets. I am an Plus

12 € EUR en 1 jour
(0 Commentaires)
0.0
rrathor80

A proposal has not yet been provided

23 € EUR en 1 jour
(0 Commentaires)
0.0
kalchevatanas

A proposal has not yet been provided

19 € EUR en 1 jour
(0 Commentaires)
0.0