Probably one of the most common questions. Unfortunately, there's no simple answer that comes straight from the box (at least, not using T-SQL).
You can do several things:
1. Create a very cumbersome SELECT statement using CASE statements.
2. Use MS Access as your front-end with linked tables to your SQL Server
3. Buy one of a couple of 3rd party tools: