Make the Script or Macro to clear the Excel sheet

Hello all, I need an Excel/Python expert to do the following: Remove all rows under "Owner1" with the following: LLC, Corp, Corporation, Assoc, Associates, Properties, Rt, Ft, Nt, Inc and any rows with “T” at end of name (ex. “Green Line T”) or “Est” at end of name (ex. “Green Line Est”) You will then put all of these into separate Excel sheet. For the remaining "Owner1" and "Owner2", you will create separate columns for Owner1 and Owner2 First Name, Last Name, Middle Name and Middle Initial(s). If there is a "Tr" at the end of any name, you will remove it and add it to a new column labeled "Trustee". The Trustee column should be the next column after the last name. If the first or last name is hyphenated, keep both. (ex. Jing-Ling Jones or Bob Jones-Johanes) If the 5 digit "Zip" and "Owner_Zip" field has an additional 4 digits (ex. 02144-3449) then put the last 4 digits in a new column next to the Zip/Owner_Zip fields.