I have a data in excel following way.



Assume only two columns,

1st column is for name

Second column for address.



If the address has 5 lines, the name repeating 5 times in first column and
different address lines in the next column.

Example





Name Address



RON Add line 1

RON Add Line 2

RON City

RON postal code

BOB Address 1

BOB Address 2

BOB City

JAIN Address 1

JAIN City



How can I merge this data to the word document in such a way that the name
will come only once and all the address lines related to a particular record
in same page.

From above example I need to get only three merged documents.

Can somebody help? I have tried nextif but could not workout.



I can not change the data as it is importing from other source and is very
large than I have shown above.



Thanks in advance.



Jasy