Turning rows into columns.

[DASeb]

Hi Forum,

I'm trying to merge information from a table that generates new rows for each year an employer is active. I would like to have it be listed in a single row for each employer, with confirmation of the years active in separate columns.




Problem Table:

Employer 1	AccountID 1	2015
Employer 1	AccountID 1	2016
Employer 2	AccountID 2	2016

How I would like it to appear in my table with all the other information:

Employer	Active 2015?	Active 2016?
Employer 1	Yes	Yes
Employer 2	No	Yes

I currently do this in 3 steps, but am curious to find out if there is a quicker solution. First I run two queries to list off the employers for a given year, THEN merge them into the final table.

Thanks for taking a look at this!

[JamesDeckert]

Your problem table is the way normalized DBs are designed. The way you want it will continue to require maintenance in the future 2017, 2018, etc.
So before you go that route, what is your reasoning for want to do it that way?