I have a huge list of last name, home number, street and city
My goal is to separate the info into:
Street Name
House Number Last Name

i.e.
HIGGINS 1173 Birch Bark Ct
ARBINO 1177 Birch Bark Ct
SCHLOEMER 1185 Birch Bark Ct

could appear as:

Birch Bank Ct
1173 HIGGINS
1177 ARBINO
1185 SCHLOEMER

Thoughts?