Hi,

I have a Contact List and each Contact occupies exactly 4 rows with a blank
row in between each Contact. Each row varies in the number of columns that
are used but the longest is A thru F. Each Contact has the word 'Contact' in
Column A in the starting row for each Contact.

What I like to be able to do is have all the Conact info on a single row so
starting in the second row cut the info and append it to the first row and
do the same for row 3 and 4.

Knowing a little bit about VBA I thought that using the word 'Contact'
because it is a consent in each Contact it could be used to identify the
start of each new contact.

Could one of you please help me this this code as it would be greatly
appreciated.

James