Thanks for the explanation.

I've got two problems. The first is that the 3 memo fields in my table do not get included in the array when I "scatter to laAddRow". So this causes a problem with matching up the number of array elements and the number of fields.

The second is I don't understand why you are checking the non-empty values from the 2nd field. Is it that you were assuming the first field is the key field? If so, that's not correct, the key field can be anywhere in the table.

>Frank,
>
>>I'll see if I can understand what the code is doing. At this point in time I don't know the size of the tables I'll be dealing with either.
>
>it scans your table to merge in order of the key field, it uses laData to hold all the merged columns until the key field changes then it pushes the laData array out to the new destination. if the key field is the same it just stuffs the non-empty values for the 2nd through Nth rows (via the laAddRow array) over the top of the laData element. Now if you have multiple rows that have values for field2 the last non-empty one wins, that may or may not be what you want.