palaeontology
Active Member
- Joined
- May 12, 2017
- Messages
- 444
- Office Version
- 2016
- Platform
- Windows
Hi all,
I have the following data in the range C1:D15 ...
<colgroup><col><col></colgroup><tbody>
</tbody>
You'll notice that in the 'Original' column, a student name may appear more than once, which indicates they have more than one parent who supplied an email address (found in column D).
What I would like to do is to have column D converted to 2 lists, resembling the following ...
<colgroup><col><col></colgroup><tbody>
</tbody>
I'd prefer this to be done by formula rather than code, if at all possible.
Kind regards,
Chris
I have the following data in the range C1:D15 ...
Original | |
Barber, Isabella (59792) | melissa.barber@bigpond.com |
Barber, Isabella (59792) | robert.v.barber@hotmail.com |
Bell, Maya (83298) | gaye.grahambell@bigpond.com |
Bellamywells, Lewis (64795) | alanbw@ccpl.net |
Bellamywells, Lewis (64795) | bellamywells@hotmail.com |
Brueckner, Amber (87862) | leannebrue@hotmail.com |
Brueckner, Amber (87862) | rodrcsmith@gmail.com |
Chapman, Jack (66886) | david@propertynorth.com |
Chapman, Jack (66886) | dee@propertynorth.com |
Combarngo, Xaire (83652) | lspence731@gmail.com |
Deeb, Sophie (72844) | mldeeb@bigpond.com |
Deighton, Fraser (88604) | brett.deighton@bigpond.com |
Deighton, Fraser (88604) | jo.hardwick@bigpond.com |
Green, Oscar (83077) | nbgreen@bigpond.net.au |
<colgroup><col><col></colgroup><tbody>
</tbody>
You'll notice that in the 'Original' column, a student name may appear more than once, which indicates they have more than one parent who supplied an email address (found in column D).
What I would like to do is to have column D converted to 2 lists, resembling the following ...
Parent A | Parent B |
melissa.barber@bigpond.com | robert.v.barber@hotmail.com |
gaye.grahambell@bigpond.com | |
alanbw@ccpl.net | bellamywells@hotmail.com |
leannebrue@hotmail.com | rodrcsmith@gmail.com |
david@propertynorth.com | dee@propertynorth.com |
lspence731@gmail.com | |
mldeeb@bigpond.com | |
brett.deighton@bigpond.com | jo.hardwick@bigpond.com |
nbgreen@bigpond.net.au |
<colgroup><col><col></colgroup><tbody>
</tbody>
I'd prefer this to be done by formula rather than code, if at all possible.
Kind regards,
Chris