Excel: how do I group a row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have different pieces of information in each column relating to a single
client eg. A1=job no:, A2=client name, A3=age etc. In the b, c, d, e rows
there are new clients with similiar information. My question is: Is it
possible to "group" all the information in the A row so when I want to "sort
by client name" all the information in the A row will follow its assigned job
no?

At the moment when I want to sort by age, only the "age" column will change
but the other information relating to the client remains static.

Any ideas?

Thanks
 
You need to select all your data before using Data | Sort
In the Sort Options set the sort for left to right
Please try to use "row" and column" correctly
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
 
Select the relevant range of data (rows and columns) before you impose the
Sort command. Don't let Excel guess what you want to include.
 
Back
Top