Combining information from 8 columns

Closed
JLS - Feb 25, 2010 at 12:58 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 25, 2010 at 01:28 PM
Hello,
I have a spreadsheet with 8 columns of data including the following headings

Business Name, Street #, Street Name,Tel #, Contact Name, Contact #, Alternate Contact, Alt. #

I would like to be able to sort the information by both alphabetical business name and also the street # and name. I cannot figure out how to link all the information so that when I sort the info it doesn't just sort the one column it sorts all the information with it.

thanks for your help.
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 25, 2010 at 01:28 PM
Just select all columns before you start sorting
0