I have a spreadsheet where every name is stored as “Last, First” in a single column and each full address sits in another column that mixes street, unit, city, state, and ZIP. The task is straightforward: • Flip each name to “First Last.” • Parse the address field - street, unit (we have more than four unit labels such as Apt, Suite, Bldg, #, etc.), city, state, and ZIP - into dedicated columns. • All records are domestic, so no country field is needed. The data is only somewhat consistent, so I’m fine if you rely on a blend of Excel formulas, VBA, Power Query, or a quick Python script—whatever gets clean, reliable results. When you’re done I expect a tidy workbook with clearly labeled columns, no broken rows, and the original order preserved. If you’ve handled messy address splits before, this should be a quick win. The list include 5429 addresses. Example of what it is now is attached.