Hi All,
I have a situation where in I have to group data by country and after each country is over, a separate header has to be given when a new country name begins.
for eg :
ID | NAME | COUNTRY |
12 | AB | AUS |
35 | CD | IND |
64 | LE | AUS |
78 | OI | IND |
95 | FG | SUI |
21 | LF | SUI |
65 | PO | UK |
17 | LQ | UK |
This data has to look like :
ID | NAME | COUNTRY |
12 | AB | AUS |
64 | LE | AUS |
ID | NAME | COUNTRY |
35 | CD | IND |
78 | OI | IND |
ID | NAME | COUNTRY |
95 | FG | SUI |
21 | LF | SUI |
ID | NAME | COUNTRY |
65 | PO | UK |
17 | LQ | UK |
Hope its clear.
Thanks in advance
Solved! Go to Solution.