How Merge 2 files with same acc# in each file
 

I would like to merge data from one workwheet into another and combine the
data. Both WS have a account # as one the column. Would like all the data
associated with Acc# 123 in WS 1 to combine with all the data in WS 2 for
Acc# 123 to merge.

WS 1 WS 2
Acc# Name Amount Acc# City
QTY Name
123 Jones 39.95 123
Anytown 4 Jones

This is what I would like to happen....can this be done? Kate

Merged WS1 and WS 2

Acc# Name Name Amount City QTY
123 Jones Jones 39.95 Anytown 4