Dear All, I am struggling with this issue for a while.
In the attached file, Question 19 corresponds to the quantity of product found at a customer's during the inspection (each product is on a line); therefore, as many products found at the customer, we will have as many lines for this customer. From this, I would like the answers for the other questions of the survey for each customer inspected to be repeated on all the lines referring to the different products found at the same customer.
How can we make it possible automatically in Excel?
Thank you very much for your help
EDIT:
To add to the post above.
I would like to automatically switch from the file downloaded before to this file attached to this post.
In the attached file, Question 19 corresponds to the quantity of product found at a customer's during the inspection (each product is on a line); therefore, as many products found at the customer, we will have as many lines for this customer. From this, I would like the answers for the other questions of the survey for each customer inspected to be repeated on all the lines referring to the different products found at the same customer.
How can we make it possible automatically in Excel?
Thank you very much for your help
A3.xlsx | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | |||
1 | Q14. Source d'approvisionnement du POS | Q15. Selectionner le type de commerce | Q16. Disponibilité des produits | Q17. Indiquer la provenance des produits observés | Q19. Choisir les produits présents chez le client | Q20. Choisir l'emballage du POS | Q22. CDE BRA? | Q23. CDE COMPETITION? | Q24. COMMUNICATION PRIX? | Q25. PEINTURE LOS? | Q26. ELECTRICITE? | ||
2 | CAMION-DEPOT | DEPOT DE BOISSONS GAZEUSES | MIXTE | MIXTE | AA | MIXTE | OUI | NON | NON | OUI | NON | ||
3 | BB | ||||||||||||
4 | CC | ||||||||||||
5 | DD | ||||||||||||
6 | EE | ||||||||||||
7 | FF | ||||||||||||
8 | GG | ||||||||||||
9 | HH | ||||||||||||
10 | II | ||||||||||||
11 | CAMION | DEPOT DE BOISSONS GAZEUSES | MIXTE | MIXTE | JJ | MIXTE | OUI | NON | NON | OUI | NON | ||
12 | KK | ||||||||||||
13 | MM | ||||||||||||
14 | LL | ||||||||||||
15 | NN | ||||||||||||
16 | WW | ||||||||||||
17 | EE | ||||||||||||
18 | DEPOT | BOUTIQUE-BAZAR | GLACE | MIXTE | DD | MIXTE | OUI | NON | NON | NON | OUI | ||
19 | EE | ||||||||||||
20 | II | ||||||||||||
21 | JJ | ||||||||||||
22 | CAMION-DEPOT | BOUTIQUE-BAZAR | GLACE | MIXTE | KK | MIXTE | OUI | NON | NON | OUI | NON | ||
23 | OO | ||||||||||||
24 | UU | ||||||||||||
25 | RR | ||||||||||||
26 | ZZ | ||||||||||||
Export |
EDIT:
To add to the post above.
I would like to automatically switch from the file downloaded before to this file attached to this post.
A4.xlsx | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | |||
1 | Q14. Source d'approvisionnement du POS | Q15. Selectionner le type de commerce | Q16. Disponibilité des produits | Q17. Indiquer la provenance des produits observés | Q19. Choisir les produits présents chez le client | Q20. Choisir l'emballage du POS | Q22. CDE BRA? | Q23. CDE COMPETITION? | Q24. COMMUNICATION PRIX? | Q25. PEINTURE LOS? | Q26. ELECTRICITE? | ||
2 | CAMION-DEPOT | DEPOT DE BOISSONS GAZEUSES | MIXTE | MIXTE | AA | MIXTE | OUI | NON | NON | OUI | NON | ||
3 | CAMION-DEPOT | DEPOT DE BOISSONS GAZEUSES | MIXTE | MIXTE | BB | MIXTE | OUI | NON | NON | OUI | NON | ||
4 | CAMION-DEPOT | DEPOT DE BOISSONS GAZEUSES | MIXTE | MIXTE | CC | MIXTE | OUI | NON | NON | OUI | NON | ||
5 | CAMION-DEPOT | DEPOT DE BOISSONS GAZEUSES | MIXTE | MIXTE | DD | MIXTE | OUI | NON | NON | OUI | NON | ||
6 | CAMION-DEPOT | DEPOT DE BOISSONS GAZEUSES | MIXTE | MIXTE | EE | MIXTE | OUI | NON | NON | OUI | NON | ||
7 | CAMION-DEPOT | DEPOT DE BOISSONS GAZEUSES | MIXTE | MIXTE | FF | MIXTE | OUI | NON | NON | OUI | NON | ||
8 | CAMION-DEPOT | DEPOT DE BOISSONS GAZEUSES | MIXTE | MIXTE | GG | MIXTE | OUI | NON | NON | OUI | NON | ||
9 | CAMION-DEPOT | DEPOT DE BOISSONS GAZEUSES | MIXTE | MIXTE | HH | MIXTE | OUI | NON | NON | OUI | NON | ||
10 | CAMION-DEPOT | DEPOT DE BOISSONS GAZEUSES | MIXTE | MIXTE | II | MIXTE | OUI | NON | NON | OUI | NON | ||
11 | CAMION | DEPOT DE BOISSONS GAZEUSES | MIXTE | MIXTE | JJ | MIXTE | NON | NON | OUI | OUI | OUI | ||
12 | CAMION | DEPOT DE BOISSONS GAZEUSES | MIXTE | MIXTE | KK | MIXTE | NON | NON | OUI | OUI | OUI | ||
13 | CAMION | DEPOT DE BOISSONS GAZEUSES | MIXTE | MIXTE | MM | MIXTE | NON | NON | OUI | OUI | OUI | ||
14 | CAMION | DEPOT DE BOISSONS GAZEUSES | MIXTE | MIXTE | LL | MIXTE | NON | NON | OUI | OUI | OUI | ||
15 | CAMION | DEPOT DE BOISSONS GAZEUSES | MIXTE | MIXTE | NN | MIXTE | NON | NON | OUI | OUI | OUI | ||
16 | CAMION | DEPOT DE BOISSONS GAZEUSES | MIXTE | MIXTE | WW | MIXTE | NON | NON | OUI | OUI | OUI | ||
17 | CAMION | DEPOT DE BOISSONS GAZEUSES | MIXTE | MIXTE | EE | MIXTE | NON | NON | OUI | OUI | OUI | ||
18 | DEPOT | BOUTIQUE-BAZAR | GLACE | MIXTE | DD | MIXTE | OUI | NON | NON | NON | OUI | ||
19 | DEPOT | BOUTIQUE-BAZAR | GLACE | MIXTE | EE | MIXTE | OUI | NON | NON | NON | OUI | ||
20 | DEPOT | BOUTIQUE-BAZAR | GLACE | MIXTE | II | MIXTE | OUI | NON | NON | NON | OUI | ||
21 | DEPOT | BOUTIQUE-BAZAR | GLACE | MIXTE | JJ | MIXTE | OUI | NON | NON | NON | OUI | ||
22 | CAMION-DEPOT | BOUTIQUE-BAZAR | GLACE | MIXTE | KK | MIXTE | OUI | NON | NON | OUI | NON | ||
23 | CAMION-DEPOT | BOUTIQUE-BAZAR | GLACE | MIXTE | OO | MIXTE | OUI | NON | NON | OUI | NON | ||
24 | CAMION-DEPOT | BOUTIQUE-BAZAR | GLACE | MIXTE | UU | MIXTE | OUI | NON | NON | OUI | NON | ||
25 | CAMION-DEPOT | BOUTIQUE-BAZAR | GLACE | MIXTE | RR | MIXTE | OUI | NON | NON | OUI | NON | ||
26 | CAMION-DEPOT | BOUTIQUE-BAZAR | GLACE | MIXTE | ZZ | MIXTE | OUI | NON | NON | OUI | NON | ||
Export |
Last edited by a moderator: