Addresses on four lines with one line between or single CSV row

So, I am trying to upload thousands of addresses to Salesforce (first they were actual labels, I scanned them and then converted them from PDF to Word and then opened them in Excel).

1) I need to have them either in a single row, each part of the address in a separate column (First Name, Last Name, Company, Shipping Street)

or

2) I need them to be in the following format:sample addresses.xlsx
Name
Company
Street Address
City, State & Zip



I was told I might be able to use 'Trim' to accomplish this, but I still need help with that if that is indeed the solution. Right now the spreadsheet's formatting is all over the map, so I do realize this might take multiple steps. The attachment is a few redacted addresses.

Thanks!!!

bump for answer

sample addresses.xlsx

Yes! Here it is. And thanks in advance for your help!

Before
xtephen G. Xeidorn Xohnxon xontrolx, Inx.
9844-B xouthern Pinex Boulevxrd
xhxrlotte, Nx x8x75

Jxmex x. Thomxx
J.x. Thomxx xervixe xorporxtion
4085 Nine Mxxxrlxnd Drive
xlphxrettx, Gx 30004

Xomxine R. xxmerx
Johnxon xontrolx, Inx.
1350 Northmexdow Pxrkwxy, xuite 100
Roxwell, Gx 30076-0000

Jxmex M. xxrr Johnxon xontrolx, Inx.
xx5 Green xtreet, xuite 901
xxyetteville, Nx x8301

After
First Name Last Name Company Street Address City State Zip
Xomxine xxmerx Johnxon xontrolx, Inx. 1350 Northmexdow Pxrkwxy, xuite 100 Roxwell, Nx x8301



Not all of the address are in four lines, some are in three or two.

sample addresses.xlsx

I think this is the correct sample, sorry for the mix up....

sample addresses.xlsx

ok, this is frustrating, you can't preview the doc before you post...

One more try....

ok, THAT is the correct example.