Hi All
I have in Sheet1 Column A the data for about 3000 contacts which I want to split into individual contacts on sheet 2 going accross the columns.
The problem is that some of the contacts use 4 rows, others 5 and some 6. This is causing me all sorts of problems.
The only saving grace that I think may help is that at the end of every contact is a cell with the telephone number followed by the text "More information" for example:
Existing Format
<colgroup><col></colgroup><tbody>
</tbody>Any help would be greatfully appreciated as I've almost pulled whats left of my hair
Cheers
Paul
I have in Sheet1 Column A the data for about 3000 contacts which I want to split into individual contacts on sheet 2 going accross the columns.
The problem is that some of the contacts use 4 rows, others 5 and some 6. This is causing me all sorts of problems.
The only saving grace that I think may help is that at the end of every contact is a cell with the telephone number followed by the text "More information" for example:
Existing Format
<colgroup><col></colgroup><tbody> </tbody>
<colgroup><col><col><col><col><col><col></colgroup><tbody> </tbody> | |||||||||||||||||||||||||||||||||||
<colgroup><col></colgroup><tbody>
</tbody>
Cheers
Paul