I have a table with different viruses in different columns ( with rows description of detected/non detected)
I need them to be in one column with virus names in rows.
I tried to stack them. However, some patients have more than one virus. I would ideally want them to be in a columns like Virus 1 ( in majority of patients there would be only one virus), Virus 2 ( if there are two virus) , Virus 3 ( if there are three virus)
If( Row() == 1 | :Subject != Lag( :Subject ), :Virus# = 1, :Virus# = Lag( :Virus# + 1 ) )
I was able top get to step4 pretty easily but am stuck at the formula. I am assuming simply copying and pasting formula would not work!
You referred to Subjects, so I assumed the name of the column that has the subjects name of ID was called "Subject". Apparently that is not the case. It appears that the column MRN is the column, but you refer to it as Mr No in the jpg you posted
I have modified my initial response to give more specifics that should provide you with your answers.