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