Merge two rows if they share a common datapoint?

[former_member1086992]

Hello,

I am new to using Business Objects. I have created a query that produces this report:

..but based on sharing the same "Specimen Number" I would like to condense it to this:

Is this possible, please? Thanks!

[ayman_salem]

If the original "date of receipt" and / or "date of birth" contains the time, you should define new variables with the date (without time) and use them in your table.

=FormatDate([date]; "MM/dd/yyyy")