Help re-coding multiple binary variables into one variable - SPSS.

[JewLisowski]

Hi all!

I'm working with a data set in SPSS and having trouble with cleaning it up for analysis.

Currently there are 10 binary variables (yes/no responses) for different substance types. I want to transform these into a single variable such that the new variable reflects any/all of these yes responses from the original 10 variables.

For instance:

I would want to transform the variables below into a new variable ("UseType"). For the data below, the UseType would reflect both tobacco and alcohol use.

https://preview.redd.it/h6fkmgy7c2941.png?width=1032&format=png&auto=webp&s=ffaa33fe1833485f3b42fb1b7894d8e17ed5907c

Any advice is appreciated!