![aggregating multiple values into one result set using sql](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisuIXN-tSxhiA8PDIbVd9Uz4H-CLs4rePo-U-McWOcMMD-mAdXHYzhk4EKZl8OR0ByCY_2TCTXiUuCJrg9bZcYgf7pksXa3l0HpoUIFioUmwvmG2jnd_HmEvxnZ7Kf2m74QbI7lRFkGhlh/s200/sql.png)
There are times when I have want an easy way to put values from a file, or table, "horizontally" into one column rather than vertically with more than one row.
"Vertical" | "Horizontal" |
TYPE THING ANIMAL ELK ANIMAL HAWK ANIMAL MEERKAT ANIMAL ORCA |
TYPE THINGS ANIMAL ELK, HAWK, MEERKAT, ORCA, SEA L FRUIT APPLE, FUJI, BLACKBERRY, GRAPEF VEGETABLE SQUASH |