How to sort two different column groups in Excel?

[PyrateWench]

I'm making a phone directory for an apartment that looks like this:

Unit__Name___Phone_______ Unit___Name____ Phone
1____Smith____ 555-5555 _____4____Bob___ 555-5555
2____Mary____ 555-5555 ______5____Jeff____ 555-5555
3 ___Jones___ 555-5555 _______6____Sally___ 555-5555

Need it to also look like this:

Unit__Name___Phone_______Unit___Name__… Phone
4____Bob____ 555-5555 _____2_____Mary___ 555-5555
5____Jeff____ 555-5555 _____6_____Sally____ 555-5555
3 ___Jones___ 555-5555 _____1_____Smith___ 555-5555


Need two sheets - one that is sorted by Unit Numbers, the other list needs to be sorted alphabetically by the person's name and since there's two lists set up on the page, I don't know how to A-Z sort them together without it having one A-Z list on the left and one A-Z list on the right, and it needs to start out with A on the left and continue to the 2nd list on the right to end with Z.

I know if it was all one list I could highlight the three columns to sort A-Z by name - but I made two columns of unit/name/numbers next to each other so it will print on one page.

1.) Is there a way to connect A,B,C with D,E,F so I can A-Z sort the entire list on both sides? (Because I can't just highlight the ENTIRE thing and sort or it'd only alphabetize by one column)

2.) Or is there a way if I made just one long list of Unit/Name/Number going down - and then somehow get that to print two up on a page? Like in Microsoft Word if you make a page 2 columns, when you get down to the bottom it moves to the other half of the page rather than continuing to page 2. Because I want this list to all fit on one page - two lists like shown, rather than printing on two pages.

Thanks.

[beaunydal]

Maybe have the one long list that you sort and another list generated by formulas that split the long list into two. See attachment.

Beau Nydal