I have two tabs in one work book
Tab1 looks like this:
work order# (column a)
123
124
128
135
Tab2 looks like this:
column a b c
Porder# vendor name amount
123 Edna $100
123 Susan $200
123 Susan $300
123 Richard $50
156 Becky $250
156 Sussie $100
135 StarCraft $200
128 David $100

I want to pull up all the vendor names and its resptected amount with the
Porder# in tab1 from tab2, eg:
Porder vendorname amount
123 Edna, Susan, Richard $100, $500, $50
156 Becky, Sussie $250, $100
135 StarCraft $200
128 David $100

Would you help me? Thanks for your help in advance!