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
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