I have a Commerce site selling clothing. Some Product Displays have multiple Commerce Products associated with them, and some have only one Product associated with them.
For example...
Shirt - Large - $10
Shirt - Medium - $8
Pants - One Size Fits All - $20
I need to use Views to display the title and price fields, as well as a link to the Product Display. I am using the Taxonomy term (Content) view with the Relationship "Content: Referenced products". I added the Title field, the "Size" field, and the "Commerce Product: Price" field, and enabled the "Distinct" setting in the Query Settings section. The result is as follows (fields are separated by a dash):
Shirt - Large - $10
Shirt - Medium - $8
Pants - One Size Fits All - $20
But I need the two "Shirt" items to be combined into a single line, like this:
Shirt - Large:$10 - Medium:$8
Pants - One Size Fits All - $20
Is it possible to combine products that have the same exact title (in this case, "Shirt")? There is only one Shirt product display page, on which the customer can choose Large or Medium.