SOLVED
SPLIT DATA USING A SPECIFIC COLUMN AND ADD COLUMN NAMES
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Shahas
8 - Asteroid
‎04-21-2023
05:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Data Investigation
- Optimization
- Workflow
10 REPLIES 10
‎04-23-2023
11:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/18F3BF3EB54AD3C2739B5AA9B77A7F97/responsive_peak/images/icon_anonymous_message.png)
- « Previous
-
- 1
- 2
- Next »