I have a Group Title at top for every group. How to fill Group Title (red text) besides subordinate for every group as shown below.
Book1.xlsm | |||||||||
---|---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | I | |||
1 | |||||||||
2 | ALPHA | Lime | ALPHA | Lime | |||||
3 | Orange | ALPHA | Orange | ||||||
4 | Papaya | ALPHA | Papaya | ||||||
5 | Manggo | ALPHA | Manggo | ||||||
6 | Corn | ALPHA | Corn | ||||||
7 | BETA | Banana | BETA | Banana | |||||
8 | Corn | BETA | Corn | ||||||
9 | Apple | BETA | Apple | ||||||
10 | CHARLIE | Grape | CHARLIE | Grape | |||||
11 | Orange | CHARLIE | Orange | ||||||
12 | Lemon | CHARLIE | Lemon | ||||||
13 | Strawbery | CHARLIE | Strawbery | ||||||
14 | Cucumber | CHARLIE | Cucumber | ||||||
Sheet1 |