+ Reply to Thread
Results 1 to 10 of 10

Sorting and rearranging contact information.

  1. #1
    Registered User
    Join Date
    07-24-2013
    Location
    University of Illinois
    MS-Off Ver
    Excel 2013
    Posts
    6

    Sorting and rearranging contact information.

    This being the first time I have used excel I am having some trouble figuring out how to do this most efficiently.
    I am copying large lists from webpages of peoples names, contact information, etc. to put into an online database at work.
    These list are long and they are all differently formatted and I need to arrange all the data to its respective column, ie "First Name, Last Name, E-mail Address, etc.
    I have seen excel features that look very useful for what I am trying to accomplish. Flash-fill, pivot tables, etc. My boss would like me to make this process nearly instant.
    Thank you for your help!

    -Ron

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Sorting and rearranging contact information.

    Upload a worksheet with representative data showing all the differences that you have in the data and an example of what you expect as a result. Then, we may be able to come up with a few useable solutions for you.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    07-24-2013
    Location
    University of Illinois
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Sorting and rearranging contact information.

    Making a mock up now! Thank you!

  4. #4
    Registered User
    Join Date
    07-24-2013
    Location
    University of Illinois
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Sorting and rearranging contact information.

    Here is a mock of what I am doing. The first two sheets are examples of how the spreadsheet looks when i copy the information in. Very messy. Each sheet is different when pasted in. Data is arranged differently etc. The third sheet is an example of how I would like to organize the first two.
    Thank you again for your help.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-24-2013
    Location
    University of Illinois
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Sorting and rearranging contact information.

    I've been told that there is a quick trick to do what I am needed to.

  6. #6
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Sorting and rearranging contact information.

    Does your data arrive as a comma separated values files (CSV) or is it in some other format before you copy the values into Excel?

  7. #7
    Registered User
    Join Date
    07-24-2013
    Location
    University of Illinois
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Sorting and rearranging contact information.

    I just copy and paste.

  8. #8
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Sorting and rearranging contact information.

    Can you get the person who sends you this data to format it in a more friendly manner? If your sample is any indication of what you get, the number of fields vary and there is little to determine what separates different elements of the data. For example, the address isn't even contained in a single cell but is a combination of a few cells.

    If the data received is in a consistent format, it would be much easier to deal with.

    What is the program that is the source of this data?

  9. #9
    Registered User
    Join Date
    07-24-2013
    Location
    University of Illinois
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Sorting and rearranging contact information.

    I dont have a way of getting it in a more friendly format. I copy and paste this information off websites and onto a spreadsheet.

  10. #10
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Sorting and rearranging contact information.

    Can you post the URL that you are copying from? Perhaps a Query could be set up to extract the data that you use.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Combining Duplicate contact information
    By ParksideDR in forum Excel General
    Replies: 3
    Last Post: 11-19-2011, 02:47 AM
  2. contact information form (template)
    By simpson in forum Excel General
    Replies: 1
    Last Post: 10-23-2011, 01:13 PM
  3. Format Change For Contact Information
    By AYU in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-11-2007, 05:44 PM
  4. rearranging information!?!
    By Dfoth in forum Excel General
    Replies: 3
    Last Post: 11-29-2006, 11:38 AM
  5. Support Contact information
    By bankerjack in forum Excel General
    Replies: 1
    Last Post: 03-16-2005, 04:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1