so1id
New member
- Joined
- Oct 23, 2012
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hi everyone,
Sorry to be "that guy" who shows up with one post to his name asking for help, but I could do with a friendly point in the right direction, I'm not the most advanced of excel users...
Here's my problem:
Where I work I've been given a bit of a side project to do, it's pretty dull but it involves getting contact info for certain companies from one messy spreadsheet into another. The email addresses are listed horizontally across cells in some cases, and in a LOT of the others they are all in one cell split by semi-colons. I need to find a way to quickly transpose these whilst keeping the company names/id's/other relevant info intact corresponding with the email addresses.
I know about "Paste Special>Transpose" but it's still rather time consuming, and the bigger problem is the addresses grouped in one cell split by semi-colons.
I've attached an example workbook with two worksheets showing what I'm starting with and what I hope to end up with...
If anyone has any way this could be done easier than copy and pasting one by one I'd be most appreciative! Thanks a lot...
P.s. I wasn't sure if this was a problem that could be solved with a formula or if there's some other way to do this within the excel interface, as such I hope I'm in the right sub forum!
Sorry to be "that guy" who shows up with one post to his name asking for help, but I could do with a friendly point in the right direction, I'm not the most advanced of excel users...
Here's my problem:
Where I work I've been given a bit of a side project to do, it's pretty dull but it involves getting contact info for certain companies from one messy spreadsheet into another. The email addresses are listed horizontally across cells in some cases, and in a LOT of the others they are all in one cell split by semi-colons. I need to find a way to quickly transpose these whilst keeping the company names/id's/other relevant info intact corresponding with the email addresses.
I know about "Paste Special>Transpose" but it's still rather time consuming, and the bigger problem is the addresses grouped in one cell split by semi-colons.
I've attached an example workbook with two worksheets showing what I'm starting with and what I hope to end up with...
If anyone has any way this could be done easier than copy and pasting one by one I'd be most appreciative! Thanks a lot...
P.s. I wasn't sure if this was a problem that could be solved with a formula or if there's some other way to do this within the excel interface, as such I hope I'm in the right sub forum!