ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sorting a Two Dimensional Table (https://www.excelbanter.com/excel-discussion-misc-queries/227385-sorting-two-dimensional-table.html)

FARAZ QURESHI

Sorting a Two Dimensional Table
 
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.

driller

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.


FARAZ QURESHI

Sorting a Two Dimensional Table
 
Empty suffixes are not yet present, however they could be removed later.
There are around 150 colums of names imported from a cell phone.

"driller" wrote:

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.



All times are GMT +1. The time now is 08:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com