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.

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.

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.