Hello,

I have a database table that is populated with multiple calculations, and then are listed by their unique list_id. These list_id's can be grouped under a specific source_id. In other words many list_ids can be under a single source_id. The data looks something like this:

ListID Source ID passback_id subid   out   in
342     519             1029           0        0   11
343     519             1030           0        0   58
344     519              0            1029    129   0
345     519              0            1030   1163   0

What i want to is merge list ID 342 and 344 together so that I can use the out and in columns in the same calculations. Is this possible let me know if you need more information.

since it is in a table, perhaps you could use a command to select table something like: