I am in need of your assistance. Below you will find various categories of testing data. My question is, how can I combine or group certain variables together?
For example, how would I combine HIV-Positive (72) with Positive (110) so that I can create a scenario where it could just be: HIV Positive = 182
Ideally under this column, I would like to restructure it in a way where I can combine negative with negative and positive with positive.
the column title is "Final.Test.Result."
|6|HIV Positive, undifferentiated|1|
|7|Inconclusive, further testing needed|30|
All the help is greatly appreciated.