Hi guys,
I have a data set that is by its nature has multiple lines for a single reference number.
So for example:
Is it possible to combine all results in CPV descirption so they appear as a single row eg:
But with spaces rather than the period?
Thanks
I have a data set that is by its nature has multiple lines for a single reference number.
So for example:
Code:
[FONT=Calibri][COLOR=#000000][/COLOR][/FONT][TABLE]
<caption>[B]Qry_Master_Vendor_Output_L1[/B]</caption><thead>[TR]
[TH="bgcolor: #c0c0c0"][FONT=Calibri][COLOR=#000000]CPVDescription[/COLOR][/FONT][/TH]
[TH="bgcolor: #c0c0c0"][FONT=Calibri][COLOR=#000000]Vendor[/COLOR][/FONT][/TH]
[/TR]
</thead><tbody>[TR]
[TD][FONT=Calibri][COLOR=#000000]Sludge disposal services.[/COLOR][/FONT][/TD]
[TD][FONT=Calibri][COLOR=#000000]1000049892[/COLOR][/FONT][/TD]
[/TR]
[TR]
[TD][FONT=Calibri][COLOR=#000000]Sludge treatment services.[/COLOR][/FONT][/TD]
[TD][FONT=Calibri][COLOR=#000000]1000049892[/COLOR][/FONT][/TD]
[/TR]
[TR]
[TD][FONT=Calibri][COLOR=#000000]Sludge transport services.[/COLOR][/FONT][/TD]
[TD][FONT=Calibri][COLOR=#000000]1000049892[/COLOR][/FONT][/TD]
[/TR]
[TR]
[TD][FONT=Calibri][COLOR=#000000]Sludge removal services.[/COLOR][/FONT][/TD]
[TD][FONT=Calibri][COLOR=#000000]1000049892[/COLOR][/FONT][/TD]
[/TR]
[TR]
[TD][FONT=Calibri][COLOR=#000000]Treatment and disposal of foul liquids.[/COLOR][/FONT][/TD]
[TD][FONT=Calibri][COLOR=#000000]1000049892[/COLOR][/FONT][/TD]
[/TR]
[TR]
[TD][FONT=Calibri][COLOR=#000000]Refuse incineration services.[/COLOR][/FONT][/TD]
[TD][FONT=Calibri][COLOR=#000000]1000049892[/COLOR][/FONT][/TD]
[/TR]
[TR]
[TD][FONT=Calibri][COLOR=#000000]Ash disposal services.[/COLOR][/FONT][/TD]
[TD][FONT=Calibri][COLOR=#000000]1000049892[/COLOR][/FONT][/TD]
[/TR]
[TR]
[TD][FONT=Calibri][COLOR=#000000]Household-refuse disposal services.[/COLOR][/FONT][/TD]
[TD][FONT=Calibri][COLOR=#000000]1000049892[/COLOR][/FONT][/TD]
[/TR]
[TR]
[TD][FONT=Calibri][COLOR=#000000]Urban solid-refuse disposal services.[/COLOR][/FONT][/TD]
[TD][FONT=Calibri][COLOR=#000000]1000049892[/COLOR][/FONT][/TD]
[/TR]
</tbody><tfoot></tfoot>[/TABLE]
Is it possible to combine all results in CPV descirption so they appear as a single row eg:
Code:
[TABLE="width: 328"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]CPVDescription[/TD]
[TD]Vendor[/TD]
[/TR]
[TR]
[TD]Sludge disposal services.Sludge treatment services.Sludge transport services.Sludge removal services.Treatment and disposal of foul liquids.Refuse incineration services.Ash disposal services.Household-refuse disposal services.Urban solid-refuse disposal services.[/TD]
[TD]1000049892[/TD]
[/TR]
</tbody>[/TABLE]
But with spaces rather than the period?
Thanks