Is there a way to merge rows in a table?

[#1]

Can I merge these records where the id are the same?

In the database 'Created by' and 'Assigned to' are id's in the 'zopus' table. I use these id's to pull the names (displayed above) from a diferent table called 'users'; using expressions as a dimensions.

Created by column:

=if(zde_created_by=user_id,Person_Name)

Assigned to column:

=if(zde_assigned_user_id=user_id,Person_Name)

In the db the all the data is collected in one row per id, but when displayed in qlikview it is seperated per expression.

[Jason_Michaelides]

Can you post your app at all?