Alphabetize Records in Google Sheets
Budget: $2 – $8 USD
I have four sample records in this Google Sheet: https://docs.google.com/spreadsheets/d/1oBnhwy67M6dvjKwyIheLSt_0Aoy7_qWv/edit#gid=34688781. Each record spans columns A through BM. I need a single Google Sheets file that reproduces that full column set exactly, then merges the four records and sorts the whole table alphabetically by the name information stored in columns AE–AF (primary first/last) and BL–BM (alternate first/last).
Acceptance criteria:
• Every original column (A–BM) is present with unchanged headers.
• Data from the four source records is combined without loss or duplication.
• The final sheet is sorted A-Z by the primary name; if two rows share the same primary name, the alternate name fields are used as the tiebreaker.
• File delivered as a shareable Google Sheet with editing rights enabled.
Acceptance criteria:
• Every original column (A–BM) is present with unchanged headers.
• Data from the four source records is combined without loss or duplication.
• The final sheet is sorted A-Z by the primary name; if two rows share the same primary name, the alternate name fields are used as the tiebreaker.
• File delivered as a shareable Google Sheet with editing rights enabled.