So I have a project where I need to pull names and place them on a letter.
I have an Excel file with 3500+ names. Those names are sorted by office number of which there are 360 offices.
Sounds simple enough, right? Well here's where it gets a little difficult.
I have to place only the names of the people who are in the same office on the same letter. So when I'm done I need to have 360 letters and each letter can only have the names of the people who are in that specific office listed in a column.
My data looks something like this:
FIrst Name Last Name Office Number
Tom Jones 001
Lisa Jones 001
Billy Jones 001
Joe Smith 002
Howard Evans 002
Mark Swan 003
Tina Epstein 004
George Winston 004
Wallace Morgan 005
So how can I pull only the people from Office Number 001 and have their names listed (in a column) on one letter and then have only the people from Office Number 002 and list just them and so on and so on...
I am using Fusion Pro Desktop 7.2
Thank You!