Creating multiple variable

[ARAJPUT_HENRY]

Hello Everyone,

Can anyone help me get to the solution of the  data shown below-

I have around 250 variables that should be summed up to 90 variables. Example- A and B are variables that need to be built. A= A1+A2+A3, B= B1+B2+B3 . I know this can be easily done by formula tool but I have to make 90 variables like that. Any dynamic solution to sum up column A 1,2, 3,4 or 5 to variable named A , B1,2,3,4 or 5 to B and likewise to create 90 variables without writing code for each variable

Thank you !

A1	A2	A3	A4	B1	B2	B3
yes				yes	Tobacco	10/17/2022
no	Diabetes			no
yes		6years	Mild	yes
yes				yes		10/17/2022
no
no	Thyroid			no
no				no
no		2 years		no
yes	Sepsis			yes	Alcohol
yes
yes				yes
yes	Heart problem			yes
yes				yes

[danilang]

Hi @ARAJPUT_HENRY 

What does your output look like

Dan

[ARAJPUT_HENRY]

Hello @danilang 

The output should look like this-

A	B
yes	yes::Tobacco::10/17/2022
no::Diabetes	no
yes::6years::Mild	yes
yes	yes::10/17/2022
no
no::Thyroid	no
no	no
no::2 years	no
Yes::sepsis	yes::Alcohol
yes
yes	yes
yes::Heart problem	yes
Yes	yes

[caltang · Accepted solution]

@ARAJPUT_HENRY like so:

[flying008 · Accepted solution]

Hi, @ARAJPUT_HENRY 

Another way of dynamic solution for  you:

[ARAJPUT_HENRY]

@caltang Thank you so much. It works perfectly.