I'm often recieving datas from an other departement in a "cross-tab" way.
red | yes | yes | no
Blue | no | no | yes
Green | no | yes | no
person1 | red | yes
person1 | Blue | yes
person1 | Green | no
MS Access does not have an UNPIVOT function which will convert your columns of data into rows but you can use a UNION ALL query:
SELECT 'person1' as IDPerson, color, person1 as activated FROM yourtable UNION ALL SELECT 'person2' as IDPerson, color, person2 as activated FROM yourtable UNION ALL SELECT 'person3' as IDPerson, color, person3 as activated FROM yourtable
See Demo (SQL Server Demo) to see working version.