A Single Row

[BAWC01]

Hi

I have multiple row containing various data in one table

0125534229  15/04/2006  10:19:13     0    ATR Line 5  No BSM
0125534229  15/04/2006  10:19:33     MC10 MC10        MCS 
0125534229  15/04/2006  10:19:36 US  MC10 MC10        BSM 
0125534229  15/04/2006  11:53:24 US  MC11 MC11        Flght
0125534229  15/04/2006  11:53:44     1    ATR Line 5 
0125534229  15/04/2006  11:54:19     0    ATR Line 5

What I would like to do is consolidate each of the indicidual line into 1 row.

Is it possible, and how can I do it

Thanks

Phil

 

[PHV]

Any chance you could post the expected output with your sample data ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

Then you must answer the following questions...
what about
column 3 with 6 values
column 4 with 2 values
column 5 with 4 values
column 6 with 3 values
column 7 with 5 values

how does this all get "consolidated"?

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[BAWC01]

Yes

I would like to select individual items from each row into 1 row I can then export, so it looks something like.

0125534229  15/04/2006  10:19:13 US MC10 ATR Line 5 No BSM MCS 11:54:19  ATR Line 5

Hope this makes it clearer

Thanks

Phil

 

[PHV]

select individual items from each row
and what are the rules ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[BAWC01]

PHV

I want to use the first time stamp and then just add items from each row into one.

Thanks

Phil

 

[PHV]

Have a look here:

http://www.tek-tips.com/faqs.cfm?fid=4233

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[BAWC01]

Thanks

I will have a go

Cheers

Phil