I am trying to sort and group my file list based on text included in the cell so that all the cells with a word are grouped together.
I am trying to organize archived files for a construction business. I have a long list of where over 2000 physical files are located. I now want to go thru the files and put all of the different files for a property together. I do NOT want to go thru 2000 cells and separate the names from the job numbers. My data looks like this:
JOB# PROPERTY LOCATION
AZ8899 Beachfront Stack 6
AZ8899 Beachfront Stack 19
AZ8900 INLAND Stack 65
AZ8901 MIDWAY Stack 4
G67890 Beachfront Stack 30
AZ0007 MIDWAY Stack 48
G62247 INLAND Stack 9
The job number and property address/name are in one cell. The location is in the next cell. There are over 2000 Job#/Property Listings that cover about 1500 different properties. If we go to a property multiple times or do multiple jobs at it, we generate a different Job number each time based on the date we do it and what we do. So Beachfront can have 34 different job numbers. Each Job#/Property has at least one location, but can have more. If someone took part of the file and did not return it, there is going to be two locations for the same file. The job numbers are only ever used once. AZ8899 only appears with Beachfront. I have no idea which jobs have multiple numbers or locations.
I want a list that has all the same properties grouped together, regardless of the job numbers, with their correct locations. I know how to sort based on the job numbers and/or the locations. I cannot figure out how to tell the sort to look for the Property info only and sort into groups based on that.
AZ8899 Beachfront Stack 6
AZ8899 Beachfront Stack 19
G67890 Beachfront Stack 30
AZ8900 INLAND Stack 65
G62247 INLAND Stack 9
AZ8901 MIDWAY Stack 4
AZ0007 MIDWAY Stack 48
Bookmarks