[Doug Robbins - Word MVP]

In the merge, don't you get

1 Category1
2
3 Catagory3

That is what I get under those circumstances

While it is still not really clear how you wish the data to be presented,
given the volume of data you are talking about, I would be using Access and
a report in Access.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"merger" wrote in message
...

Hi Doug,

In Excel I have a similar to this set up

Name,Address1,Address2,Catagory1,Catergory2,Catego ry3,Category4,Etc

So imagine the fields populated but in the Categories some fields are
empty. So I merge using

Category1
Category2
Category3
Etc.

In Word I have the numbered bullet points set against these fields.
Word then leaves out any unpopulated field but still seems to count
them so if Category 2 is empty I get

1 Category1
3 Catagory3

In the file I am dealing with I have 11 Categories and 11 Products
which need the same treatment. The file also has 10,000 records but
this may go to 100,000 so I would like to get away with manually
getting rid of all of the blanks in the spreadsheet.

Does this make sense?

Thanks




--
merger