Help with more manageable format

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.

Hey Sandy,

Thanks for your response. I appreciate your confidence in my Excel abilities... but I'm not on par with the majority of people in this forum. I didn't create the data in my attachment and I feel like your advice is geared toward the people who generated that spreadsheet. However, it was generated by someone else and sent to me. I will receive updated reports similar to the one I attached on a weekly basis and in mass quantity. I'm looking for some guided assistance in changing the formatting of the data once I receive it. I need to know how to get the rows of "Address" through "Remarks" into the same row as the individual's name.

I have a feeling what I'm asking for is so simple to you that you're assuming I already know how to do it...

Hey Sandy, I don't have access to the source files.

Attached is an additional example file. Thank you for taking the time to help.

That's what I'm looking for with the additional aspect of separating the street number from the street name, and, of course, all of the data would be in a row from subject name through remarks.

My dear friend
I'd like to see HOW you want divide ADDRESS,

eg. 23814 SJJFKKDJS APT 933
23814 | SJJFKKDJS APT 933
or
23814 | SJJFKKDJS | APT | 933

there are letters also like NESW, so I suppse this is Nord, East, South and West
or
enough number and the rest in two columns?

Thanks again for your time, Sandy. I'd like the address divided such:

23814 | SJJFKKDJS APT 933

The entire address AFTER the numbers can be in one cell. THANK YOU!

Ok,
1. if you want more data from source (from your Dept.) copy data without first and last row and paste into src sheet below previous data
2. on ind sheet you've result (to row 401), if you want more select A400:Q400 and drag down as far as you need
3. but remember, too much data will slow down your excel
4. sorry if it is not click&dance

maybe someone else will give you much better solution

see att.

Sandy, thank you very much for your time and effort. The data you produced looks exactly like what I'm looking for. This will definitely be a big help to our department. Thank you.