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