B1azingPengu1n
New Member
- Joined
- May 11, 2016
- Messages
- 4
Hey everyone,
I have a large spreadsheet with many pairs of cells like this:
Names Emails
<tbody>
</tbody>
Obviously these fields match respectively, the first item before the semicolon in the left cell corresponding to the first item in the right.
Is there a way to extract this data so that it's instead many pairs of cells, each with one item? Like this:
<tbody>
</tbody>
Thanks in advance for any help!
I have a large spreadsheet with many pairs of cells like this:
Names Emails
Chris Ritter;Ina Lucas;Tammy Willerth;''''''Eric Willerth'''''';Maya;Regina Bell;Bonita Schaufele;'Marilyn Llewellyn' |
<tbody> </tbody> |
<tbody>
</tbody>
Obviously these fields match respectively, the first item before the semicolon in the left cell corresponding to the first item in the right.
Is there a way to extract this data so that it's instead many pairs of cells, each with one item? Like this:
Chris Ritter | ceritter@telus.net |
Ina Lucas | hopelesslyoverbudget@me.com |
Tammy Willerth | twillerth@shaw.ca |
Eric Willerth | ewillerth@gmail.com |
<tbody>
</tbody>
Thanks in advance for any help!