Results 1 to 5 of 5

Thread: Splitting/transposing some contact data easily...

  1. #1

    Splitting/transposing some contact data easily...



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!
    Attached Files Attached Files

  2. #2
    will the cells with multiple emails always be in column C (Domain 1) or could they show up in any column ?

  3. #3
    Quote Originally Posted by tommyt61 View Post
    will the cells with multiple emails always be in column C (Domain 1) or could they show up in any column ?
    Yes the cells with multiple emails are all in the "first" email column, i.e domain 1

  4. #4
    See if this is what you are trying to accomplish.

    1. Click button
    2. Click yes on the message box that pops up.

    This file contains Macro Code
    Attached Files Attached Files

  5. #5
    Seeker ekavana186's Avatar
    Join Date
    Mar 2011
    Location
    Richmond, VA
    Posts
    5
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by so1id View Post
    Yes the cells with multiple emails are all in the "first" email column, i.e domain 1
    Highlight the column the data is in, Go to Data tab, select Text to Columns, select delimited, select ; (semicolon), and if I read you example correctly then TADA!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •