DarinM,
I think snb was trying to say his code will look at all the different price types in the column and generate a new column at the end of the row for each type.

How you adjusted your sheet to accommodate the 33 types and the 100 variances is not necessary (and would change each quarter anyway I believe),
his code will do it with what you have in your raw data.

I think I see what you are talking about with 1-14. For same account numbers, with same address, same price type > if more than one match:
you need a separate column added for each (sometimes up to 14) and stay in same row.

snb: could you use/make a header with a unique name as an index to find the column for inserting the matches, and if not empty create an iterated copy List(i), WCB BC(i) etc
like:
fill array with unique price types = headernames
get match for account# and address then copy row 
for x = lbound(headernames) to ubound(headernames)
if headernames(x) isEmpty then
paste matched.row there
else 
insert column 
cells(1, x +1).value = headername(x) & i
i = i +1
paste matched.row now
this is just an idea map to try coding, if you get the thought process??