How can I organize a list of business names and street addresses alphabetically in Google Sheets?

I am working in Google Sheets and have two columns of data, one containing the Business name and one containing the street address. I would like to organize them first by alphabetizing the business name, then the street address.
LVL 2
Jaime LewisMarketing Account ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RobOwner (Aidellio)Commented:
highlight the entire range and click "sort range by column_ A->Z"
RobOwner (Aidellio)Commented:
Here's an example of using a filter as well via the Data -> Filter option.  Just highlight your range first, or at least the top on one of the columns

Clipboard02.jpg
Clipboard01.jpg

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jaime LewisMarketing Account ManagerAuthor Commented:
That solves the business name, but how about the address? Is there a way to organize addresses alphabetically if the cell begins with a number?
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

RobOwner (Aidellio)Commented:
I did think about suggesting that but how many business names have the same name?  You can sort on the address by setting up the filter I've described above.  Then, by clicking the arrow at the top of the address column, you'll see the ability to sort that column.

What we're getting to, is that the data is tied together.  When you sort the business name, it sorts the addresses based on the business name so that the address stays with the business it is associated with.  If we sort each column individually, you lose the context of the data.  Does that make sense or are the addresses and business names not related?
Jaime LewisMarketing Account ManagerAuthor Commented:
I suppose I asked my question out of order. Is is possible to organize by street name first (since several of the businesses are on the same street), and then by business name?

The names and addresses are definitely related. Apologies for the unclear nature of my original question. Would it be best to resubmit an edited version or would you recommend continuing this conversation thread to ferret out an answer?
RobOwner (Aidellio)Commented:
No need to start a new question. We're just clarifying the problem :)

Again, select the range, click data, sort range.

This will give you a pop-up where you can specify a dual sort.  You should be able to specify address first, then click add, and you'll be able to select business name
Jaime LewisMarketing Account ManagerAuthor Commented:
Attached is the filter that I applied, and the results that I received. Will I have to separate out the number from the street name in order to alphabetize?
The filter appliedresult.PNG
RobOwner (Aidellio)Commented:
Yes you will but that's as easy as putting a formula in the adjacent cell and copying it down. Then sorting on that column rather than the address column
If the address is in column C
=mid(C2, FIND(" ",C2)+1,len(C2))
Jaime LewisMarketing Account ManagerAuthor Commented:
Thank you for your help! That formula is a major time saver.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Google Apps

From novice to tech pro — start learning today.