I'm pretty sure that any manipulation of the data to group items from multiple records so that they show in a single output record will cause difficulties with updating the returned recordset. Cross-Tab or aggregation (GROUP BY) queries are never updatable.
I can't think of a way to maintain the data without showing the items in their native form.