I kindly ask if there is a way to group the data from Sheet1, Sheet2, Sheet3 in a recap Sheet4.
I would like to recap only some column, the issue is that the data are in horizontal and I would like to have them in vertical.
I try to put an example here and I attach the file I'm using to be more clear.
Thank you so much for any kind of support!
Sheet1:JOB_Equipments
Sheet2:JOB_After Sales
Sheet3:Customer Complaints
Sheet4:Interventions Recap (to be generated)
I would like to recap only some column, the issue is that the data are in horizontal and I would like to have them in vertical.
I try to put an example here and I attach the file I'm using to be more clear.
Thank you so much for any kind of support!
Sheet1:JOB_Equipments
| A | B | ... | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | | | | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |
Sheet2:JOB_After Sales
| A | B | ... | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | | | | | | | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | | | | x | x | x | x | x | x | x | x | x | x | x | x | x | x | | | | | | | |
Sheet3:Customer Complaints
| A | B | ... | H | I | J | K | L | M | N | O | P | Q | R | A | T | U | | | | | | | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | | | | x | x | x | x | x | x | x | x | x | x | x | x | x | x | | | | | | | |
Sheet4:Interventions Recap (to be generated)
| A | B | ... | F | G | H | I | J | K | L | | | | | | | | | | |||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | | | | x | x | x | x | x | x | x | | | | | | | | | | | | | | |