Consolidating text data by reference number



I have a spreadsheet with 35000 lines. Each line contains a customer name and the archive box code where their information is stored. I need to consolidate this information by archive box number, i.e. I need to have a list that shows for each archive box number, all the names stored in it. 


There are 1200 archive boxes on this list – please help me so that I don’t have to copy and paste 1200 times! 


Thanks for your help in advance!

By: Claire Nixon

16 thoughts on “Consolidating text data by reference number

  1. ig

    Greetings! This is my first comment here so I just wanted to give
    a quick shout out and say I really enjoy reading your posts.

    Can you suggest any other blogs/websites/forums that cover the
    same subjects? Thanks for your time!


    I think that everything said made a bunch of sense. However,
    what about this? what if you added a little information? I mean, I don’t want to tell you how to run your website,
    however suppose you added something that grabbed folk’s attention? I mean Consolidating text data by reference number | is a little plain. You
    ought to glance at Yahoo’s home page and note how they create news headlines to get viewers to click.

    You might add a related video or a pic or two to get readers interested about what you’ve written. Just my opinion, it might bring your blog
    a little livelier.

  3. sling tv

    I relish, result in I found exactly what I was taking a look for.
    You have ended my 4 day long hunt! God Bless you man. Have a nice
    day. Bye

  4. sling tv

    whoah this weblog is excellent i really like reading your articles.
    Keep up the good work! You realize, many persons are hunting around for this information, you could help them greatly.


    You are so cool! I don’t suppose I have read
    through anything like this before. So wonderful to discover another person with genuine thoughts on this topic.
    Seriously.. thanks for starting this up. This website is
    one thing that is needed on the web, someone with a bit
    of originality!

  6. ps4 games

    Wow, awesome blog format! How long have you been blogging for?
    you make running a blog glance easy. The full glance of your website is
    magnificent, as well as the content material!

  7. quest bars cheap

    Link exchange is nothing else however it is only placing
    the other person’s web site link on your page at
    appropriate place and other person will also do same in favor of


    First off I would like to say wonderful blog! I had a quick question in which I’d
    like to ask if you don’t mind. I was interested to know how you center yourself and clear your head prior to writing.
    I’ve had trouble clearing my thoughts in getting my
    ideas out there. I truly do take pleasure in writing
    but it just seems like the first 10 to 15 minutes tend to be wasted just trying to figure
    out how to begin. Any ideas or hints? Many thanks!

Comments are closed.