I have created my query that returns the results I require however I need to change how its displayed
Company Spec company 1 spec1 company 1 spec2 company 1 spec3 company 1 spec1 company 1 spec2 company 2 spec4 company 2 spec5 company 2 spec1 company 2 spec5 company 2 spec4
I need this to be displayed like this:
Company Spec company 1 spec1 spec2 spec3 company 2 spec1 spec4 spec5
So I need the company name distinct but I want the spec values to show under the company as well rather than on each row shown above.
I know it looks like the values a duplicated but they're not - theres other columns in the database with unique values
I hope that makes sense... can anyone help me please?