Hi,

Its probably clear to others, but I'm cornfussed. You have the subvendor
numbers in column A and you want them in column C. Why not type =A2 in C2?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Jai" wrote:

Hi,

I have a list of vendors by numbers where some vendors numbers are
sub-vendors, grouped with their main vendor number. I need a formula so I can
display a list of vendors grouped with that main vendor. For example :

Col. A Col.B Col.C Col.D
Sub-Vendor No. Main Vendor Revenue
19 22 1234
20 22 456
21 22 789
Total 22 19,20,21 2,479

I need formula for Col. C so I can display all the sub-group numbers in one
column.

Please help.

Thanks
Jai