Happened to find a way to combine rows into a column. I find it quite useful, and it comes in handy.
For illustration, suppose we have UserGroup & Users. We want to list the users belonging to each group.
UserGroup:
Users:
If we do normal joining of the 2 tables, it will...
