I'm working getting the countries we've shipped to listed by item. It's was pretty easy up to the point where I was asked to list all of the countries for that item on the same line.
The way it's listed now is
Item1 Description Country
Item1 Description AnotherCountry
Item1 Description AndAnotherCountry
What i'm trying to get is
Item1 Description Country, AnotherCountry, AndAnotherCountry
Crosstab and Pivot queries aren't getting the job done.
Any ideas?
The way it's listed now is
Item1 Description Country
Item1 Description AnotherCountry
Item1 Description AndAnotherCountry
What i'm trying to get is
Item1 Description Country, AnotherCountry, AndAnotherCountry
Crosstab and Pivot queries aren't getting the job done.
Any ideas?