Hi, thanks for getting back to me quickly.

I did as you asked and highlighted the b column and its only producing 1 row on each highlight. However, it is producing the correct results its just not copying and merging all the way down to the end of the column of where the data ends.

Is there a way to produce these results and merge the c,d,e,f,g,h columns/rows and the results of the merge into the b column until the very end of where the values stopped from c,d,e,f,g, and h. It should end about 15,000 rows.

If you need a sample of the data please let me know?

thanks