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.
Thank You Shanker and binuacs.