SOLVED
Sorting Concatenated Data
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
Rahul6777
7 - Meteor
‎03-01-2023
12:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
I have 2 columns first is name and second is mail address, I want to sort my concatenated data based on the 1st column concatenation data. Please see the below current and expected.
Current | |
Name | Email Address |
Sahu, Mohan | Sharma, Ajay | Sinde, Ramesh | ajay.sharma@gmail.com | ramesh.shinde@gmail.com | mohan.sahu@gmail.com |
Prajapati, Suresh | Pandey, Jitendra | jitendra.pandey@gmail.com | suresh.prajapati@gmail.com |
Expected | |
Name | Email Address |
Sahu, Mohan | Sharma, Ajay | Sinde, Ramesh | mohan.sahu@gmail.com | ajay.sharma@gmail.com | ramesh.shinde@gmail.com |
Prajapati, Suresh | Pandey, Jitendra | suresh.prajapati@gmail.com | jitendra.pandey@gmail.com |
so, on the first column i have three names Sahu, Mohan | Sharma, Ajay | Sinde, Ramesh and in email address column also i need in same order as this mohan.sahu@gmail.com | ajay.sharma@gmail.com | ramesh.shinde@gmail.com.
Thanks,
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
3 REPLIES 3
ShankerV
17 - Castor
‎03-01-2023
12:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
binuacs
21 - Polaris
‎03-01-2023
12:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎03-01-2023
09:27 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank You Shanker and binuacs.
