Looking for any tricks to clean up a ~100k record table that has no clear pattern. The data generally looks like this all blocked together in separate rows but the same column:

JENNIFER SMITH
Accountant - Senior
Day Shift
jsmith@mail.com

AMBER Jones
Professional
Pro Status

amberj@mail.com

Abby Stone
Receptionist
Analytics
123 Main St
123-456-7890
abby@mail.com

REBECCA MILLER
Media
Building 2
millerr@mail.com
Sarah M Myers
Executive
BRADBURY SCHOOL
456 Main St
The big problem is that some records have three sets of additional data beneath it and some records have five -- maybe they have an email and/or phone number maybe they don't, some have lines after the record some don't, etc.

I'm looking for ideas either using code or formulas to attempt to clean this up to look like below without going through every line manually:

Name            Job                 Info        Email          Phone           Address
JENNIFER SMITH  Accountant - Senior Day Shift   jsmith@mail.com     
AMBER Jones     Professional        Pro Status  amberj@mail.com     
Abby Stone      Receptionist        Analytics   abby@mail.com  123-456-7890    123 Main St
REBECCA MILLER  Media               Building 2  millerr@mail.com        
Sarah M Myers   Executive           BRADBURY SCHOOL                            456 Main St

Hoping people might have ideas using scenarios they've had to use in the past on really messy datasets that come in like this; it could be some combination of using SEARCH() or LEN() to try and identify when each record's data is over -- or VBA or something.

I know it's not the most pointed question -- but if anybody has any tips it'd really help me out. It also doesn't have to end up being perfect -- if it ends up looking mildly like above, I'll be able to clean it manually from that point on, just not from the start.

Any help using any method would be greatly appreciated!