SELECT Person, "Comm 1" AS Committee
FROM Table1
WHERE (((Committee1)=True));

UNION ALL
SELECT Person, "Comm 2" AS Committee
FROM Table1
WHERE (((Committee2)=True));

UNION ALL
SELECT Person, "Comm 3" AS Committee
FROM Table1
WHERE (((Committee3)=True));