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

Leave a Reply

Your email address will not be published. Required fields are marked *