Sorry,

The desired table is not being shown correctly I mean:

Name: 1 Name: 2 Name: 3
Department: 1 Department: 2 Department: 3
Cell: xxx Cell: xxx Cell: xxx
Email: Res: xxx
Email:

i.e. 4, 5 and 3 entries in columns "A", "B" & "C" respectively.
--

Best Regards,
FARAZ A. QURESHI


"FARAZ QURESHI" wrote:

Dear Fellows,

The problem is that I commonly have a very large list imported from .txt to
.xls or .xlsx which has the blocks not of common/equal size.

An example is Column "A" showing:

Name: 1
Department: 1
Cell: xxx
Email:
Name: 2
Department: 2
Cell: yyy
Res: xxx
Email:
Name: 3
Department: 3
Cell: xxx

However, note that every new block starts with "Name" as the first 4
characters. Any idea how to convert such a data to:

Name: 1 Name: 2 Name: 3
Department: 1 Department: 2 Department: 3
Cell: xxx Cell: xxx Cell: xxx
Email: Res: xxx Email:

Your help, a fortmula or a code and guidance shall highly obliged!

--
Best Regards,
FARAZ A. QURESHI