Help ! This one should make you think !

[radar2000]

Hi everyone.

I have a bit of a problem that I need your help with.

I have an excel spreadsheet which needs to be altered...Please see sample below:

Dealer ID# Rep ID# Name
12345 abc1 jake
12345 abc2 joe
12345 abc3 phil
56789 def1 bob
56789 def2 bill

I need to transfrom the above to show the following Dearler ID# in one row...for example:

Dealer ID# Rep ID# Name Rep ID# Name
12345 abc1 jake abc2 joe
56789 def1 bob def2 bill

Please note that there may be more than 25 Rep ID#'s under one dealership. I need to have this Rep info shown across one row per each Dealership ID#.

Anyones help would greatly be appreciated.

Thank you.





_________________
Radar2000
This message was edited by radar2000 on 2002-04-16 11:02
This message was edited by radar2000 on 2002-04-16 11:03

 

[Aladin Akyurek]

Aladin, I've I needed to insert another 2 columns, how would I need to change your formula? For example, I needed to include additional data for the reps in columns D & E.

Just Insert|Columns before the current column D after clicking on D, the column indicator.

Aladin