Hello All,
I'm looking for opinion for certain task which I need to execute in this table. If you think that can be done with macro or formula. What would be the best possible way. Header2 and Header3 are on different sheet, but that can be adjusted.
I'm looking for opinion for certain task which I need to execute in this table. If you think that can be done with macro or formula. What would be the best possible way. Header2 and Header3 are on different sheet, but that can be adjusted.
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Header1 | Output which I'm looking forward after run a macro or formula in column A. Instead of CODE1, CODE2 or CODE3 print all the values in Header2 which are for that CODE and keep other records | Header2 | Header3 | |||||
2 | XXXX | XXXX | Test | CODE1 | |||||
3 | XXXX | XXXX | Test1 | CODE1 | |||||
4 | XXXX | XXXX | Test2 | CODE1 | |||||
5 | CODE1 | Test | Test3 | CODE1 | |||||
6 | XXXX | Test1 | Test4 | CODE1 | |||||
7 | XXXX | Test2 | Test21 | CODE2 | |||||
8 | CODE2 | Test3 | Test22 | CODE2 | |||||
9 | CODE3 | Test4 | Test33 | CODE3 | |||||
10 | XXXX | XXXX | Test34 | CODE3 | |||||
11 | XXXX | XXXX | |||||||
12 | Test21 | ||||||||
13 | Test22 | ||||||||
14 | Test33 | ||||||||
15 | Test34 | ||||||||
16 | XXXX | ||||||||
17 | XXXX | ||||||||
Sheet1 |