Convert Data in Multiple Rows to One Row

[SunnyDays]

I receive an excel file designed as follows, where the DealID, Amount and Fee
are the same in all the lines. The AssocName and their role change from deal
to deal:

DealID AssocName TeamRole Amount Fee
123 John Lead 14000 400
123 Susan Mgr 14000 400
123 Rudy Assoc 14000 400
456 Susan Lead 20000 500
456 Rudy Mgr 20000 500
456 John Assoc 20000 500

I'd like to see the information displayed like this:

DealID Lead Mgr Assoc Amount Fee
123 John Susan Rudy 14000 400
456 Susan Rudy John 20000 500

I've tried several things, but I always end up with multiple rows for each
DealID. Assistance is greatly appreciated!

 

[Gina Whipp]

SunnySays,

Have a look at Crosstab queries...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm