Sorting Concatenated Data

[Rahul6777]

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,

[ShankerV · Accepted solution]

Hi @Rahul6777 

One way of doing this.

Many thanks

Shanker V

[binuacs · Accepted solution]

@Rahul6777 One way of doing this

[Rahul6777]

Thank You Shanker and binuacs.