I have a few spreadsheets with a list of account numbers and their balances that I will need to combine. Each spreadsheet represents a different business entity. Some spreadsheets have more or less account numbers than the others. I was wondering how I could keep each entity in their own set of columns, and then sort the account numbers so they all line up.

Basically, I want to take two lists like these:

Please Login or Register  to view this content.
And end up with:

Please Login or Register  to view this content.
Any help would be appreciated.

Thanks!