jamovi

Hello I have two columns that are two separate conditions in an experiment.

Column A [Social EA] has text in some columns and blanks if they were in the other condition

Column B [Mundane Exp] has text where the blanks are in Column A (See Image)

I want to turn these two columns into a shared condition column

1 for if there is text in Column A and 0 if there is text in Column B

i'd use a computed variable for this, and use something like:

IFMISS(ColumnA, 0, 1)

this assumes that if there is no text in ColumnA, then there will always be text in ColumnB ... which may or may not be a correct assumption.

cheers