Is there a way to combine rows that are duplicated into a single entry?

Question

I have a query which is converted into a table. This table now contains duplicate entry's on certain columns while other columns contain unique values in a row.
Please see these 2 pictures (circled items are duplicates)
https://photos.app.goo.gl/kMjSmapW2pAXxwTj9
https://photos.app.goo.gl/qXjzdrKou32LNdjr6

I don't like the way this is presented... Is there a way to combine rows that are duplicated into a single entry... Something like this?
https://photos.app.goo.gl/MRo6ffXNWz4gLKPn8

Comments

Ok... Thanks for the info

Answer 1

The presentation looks very interesting but dbFront does not have that ability, either on the table view or the reporting side... It is possible to build the raw HTML within a stored procedure but that would be a fair bit of work.