Hi azdeji,

I understand what you are trying to achieve, but you won't be able to do it with an update, since you need to create rows for each possibility, you will have to use unions, I think it would have been a bit better to do it more with a transactional type design, but to get it to do what you want it to do you can use the code below:

SELECT Participant_ID, Supporter_ID, Event_Code, 'Speaker' AS EventRole, IsCoordinator, Speaker, IsVolunteer, IsInstructor, Attended_INT

FROM table1 t

WHERE Speaker = -1

UNION

SELECT Participant_ID, Supporter_ID, Event_Code, 'Attended_INT' AS EventRole, IsCoordinator, Speaker, IsVolunteer, IsInstructor, Attended_INT

FROM table1 t

WHERE Attended_INT = -1

just keep with the unions (copy paste), each time changing the where clause to the next column you want to check for, it will give you the desired result, I know the solution is not dynamic for when you want new "is-something" roles, but the design is already not dynamic in the sense that you have to add a new column for each possibility already,

I hope it answers your question,

Kind regards