Join rows in a column

How I can do to join, for example, 3 rows in a column, thats are commons to 3 rows of the other columns? (similar to rowspan in html tables)

—col1--------col2--------col3--------col4
---------------------------------------------------------|
------------|------------|------------|’’’’’’’’’’’’’’’’’’’’’’’| row 1
------------|------------|------------|’’’’’’’’’’’’’’’’’’’’’’’| row 2
---------------------------------------------------------| row 3

In the draw are 4 columns and 3 rows, but the last 3 rows are joined, how can do this?

is dated stored in database or do you have data in listbox that you are looking to do this with?

There’s no ability in the native listbox in a desktop app to do something like row span

If you subclass it there is! :wink:

I Can’t post a link because my website will be down for a few days as it’s server is being changed, in the meantime see:

https://web.archive.org/web/20130111023901/http://mysite.verizon.net/vzezdg8x/id5.html

The data is stored in a MySQL database. This data populate the listbox.
The data are bills with some items. The total price is common to all items.
The total price go to merged ros (common to your items)

[quote=139300:@Karen Atkocius]If you subclass it there is! :wink:

I Can’t post a link because my website will be down for a few days as it’s server is being changed, in the meantime see:

https://web.archive.org/web/20130111023901/http://mysite.verizon.net/vzezdg8x/id5.html[/quote]

Thanks Karen! I go to see and then comment.

[quote=139306:@Pablo Schwindt]The data is stored in a MySQL database. This data populate the listbox.
The data are bills with some items. The total price is common to all items.
The total price go to merged ros (common to your items)[/quote]

For your select statement, I would join the table onto itself and output the desired results to the listbox.

if you can provide example of source data and desired results, it will give me a better idea of what query should look like.