Hello Forum,
I'm a police officer in the US, and I've been working on tracking down people in my jurisdiction that have unfinished business with the court system (people with felony warrants). Today I found a way to receive more encompassing warrant lists. Those lists are in Excel format. The catch is that the format is not friendly for data sorting. I've attached an example if you have the time and are interested in helping me get this data into a more manageable form. My Excel skills are limited, which is why I'm reaching out to this community.
The bottom line is that I'm looking for all fields for each individual to be in columns, and each row to consist of data for each individual. For example, the first entry of DINGLEBERRY, THOMAS DEAN should have all of DINGLEBERRY's information across the entire row, starting with his name and ending with "Remarks". His address should consist of his address only (deleting the redundant word "Address" in the field) and I'd like to separate the street number into its own column apart from the street name so I can sort by street name at a later time.
These lists can be small like the example I have attached, or they can get up to hundreds of entries long. Once I get the appropriate steps to change the formatting, I plan on creating a macro to accomplish the task automatically (I at least know how to pull that off on my own).
Let me know what you think and thank you in advance for your time.
Bookmarks