Thanks Herb....
Unfortunately I'm stuck using a format that "Sr. Managment has become used
to"...so I can't utilize the pivot table format that you've suggested.
Is there anyway to lookup text in various cells and concatenate them
together into one cell?

"Herbert Seidenberg" wrote:

Excel 2007
Pivot Table, Auxiliary Table, Concatenate
Macro
http://www.mediafire.com/file/rojj4jzkjjw/03_04_09.xlsm