Quote Originally Posted by mperrah View Post
RealSample_snb_002b.xlsm
This has the results of snb's macro relocated to the sheet you modified to house the data (sorted by address)
some address info has been modified to conform.
I just moved it manually for now, there are still the duplicates in the columns, but if this is the start of what you want I believe we can move forward.
Yes that is exactly what I want, and just to reinforce ... when finished the 2 lines below, would become 1, and "102179-015" would be in list 2 column

A 090169-000 company ABC 1115-C AUSTIN AVE 000169-000
A 102179-015 company ABC 1115-C AUSTIN AVE 102179-015