>Your question in unclear. However, take a look at using PIVOT clause in SQL queries and even using dynamic PIVOT (there should be tons of examples).

I'll take a look at that.

The question was to simply use on table. So, during the searches, I will have those fields already in there and I will not have to use join clauses.