View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
driller driller is offline
external usenet poster
 
Posts: 740
Default Sorting a Two Dimensional Table

Do you like to see the suffix repeatedly (i.e. "Name:", "Tel.:",etc) even
without info or only those cells with infos in it.
How many columns of names do we have in the table? Are they sorted also wrt
alphabetical order?


"FARAZ QURESHI" wrote:

I have a table as follows:

Name: 1 Name: 2 Name: 3 Name: 4
Tel.: 1 Tel.: 2 Address: 3 Tel.: 4
Address: 1 Fax: 2 Fax: 3 Address: 4
Email: 1 Birthday: 2 Email: 3 Birthday: 4
Birthday: 3

How can I have it sorted as to be showing same sort of information on same
rows like as follows:

Name: 1 Name: 2 Name: 3 Name: 4
Tel.: 1 Tel.: 2 Tel.: 4
Address: 1 Address: 3 Address: 4
Fax: 2 Fax: 3
Email: 1 Email: 3
Birthday: 2 Birthday: 3 Birthday: 4

Thanx in advance.