I have the following

Col A Col Q Col Z
746 123
746 4789
746 124
748 8566
748 9586
748 852

I have this for about 3100 lines of data. I need to if Col A is the same
the return col B concatenate. So for Trailer # 746 return 123, 4789, 124 in
col Z. I did this about 2 years ago and quite frankly I had some help and no
longer remember how the macro needs to be written.

Please help. Thanks, Wanda