Append data form multiple rows to one and then delete??? 1

[WB786]

I have been given an Excel spreadsheet that has the consumer name in a repeating fashion for each of their orders.

I need to be able to put all of the repeats into just one row of a table.

Example File:

Joe Smith 555-555-5555 $500 CogOrder1
Joe Smith 555-555-5555 $600 CogOrder2
Joe Smith 555-555-5555 $700 CogOrder3

Needed Output:
Joe Smith 555-555-5555 $500 CogOrder1 $600 CogOrder2 $700 CogOrder3

etc....

Thanks,

WB

 

[WB786]

OK IT WORKS!!! I didn't see the final table that was created. I was looking only at the temp_hold table.

THANKS SO MUCH FOR THE HELP!!!



WB

 

[Blorf]

No problemo.
ChaZ

Ascii dumb question, get a dumb Ansi

 

[adventurous1]

This is a great solution in a VB setting. Does anyone know how to do this in the Oracle flavor of SQL or PL/SQL? Any help is appreciated!

adventurous1@ureach.com

 

[Blorf]

I am not familiar with Oracle, but I used VBA only to call sql queries, so there is really no vba code except docmd.runsql "Select bla bla bla"

ChaZ

Ascii dumb question, get a dumb Ansi