Changing the values of multiple columns

I'm trying to change values in multiple columns based on the value of another column.

Column Q1 holds either 1,2 or 3

Q1_1, Q1_2, Q1_3 are all blank to start.

I have tried multi-field formula:

if [Q1] = 1 then [Q1_1] = 1

elseif [Q1] = 2 then [Q1_2] = 1

elseif [Q1] = 3 then [Q1_3] = 1

else NULL()

...and it just returns zeros. Unfortunately there's quite a few of these so doing them in individual formula tools would take forever.

What would be the best way to do this?

Thanks!

Accepted answers

@srea541 Thanks for the quick response. Here is my solution to your problem.

I hope this helps!

Thanks!

Hi @srea541, could you please provide the input and output required?

The table starts like this:

I am trying to achieve this output:

Thanks!

Thank you @grazitti_sapna, I have marked your reply as solution

@srea541 Thank you so much. Much appreciated!