I have a one to many relationship of Car Companies and their Models that I would like to represent using a Data Grid. The Car Companies entity is a list of different car companies with other information about them such as year founded and headquarters. The car models entity has an attribute that is the Company Identifier, as well one different car model per row. Within the Data Grid, I would like each row to represent one unique car company, and then have one column that would contain all of the car models for that car company in a concatenated list most likely. I have included a screenshot of what this would look like if I made it in Excel. Let me know if you need any more clarifying information.

Thanks,

Charlie 

Hi @Charlie Highum,

By the image you're showing, that doesn't seem to be something that should be handled by the Data Grid itself, but by the query that is bound to it since you show two columns where the second one by your description is a text resulting from a comma-separated list of another column. 

The other way is to try the most usual approach when working with a spreadsheet:

Cheers,
GM