Hello All,

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."

|1||328|

|2|Discordant|5|

|3|HIV-1 Negative|88|

|4|HIV-1 Positive|72|

|5|HIV Negative|5304|

|6|HIV Positive, undifferentiated|1|

|7|Inconclusive, further testing needed|30|

|8|Invalid|10|

|9|Negative|37722|

|10|Positive|110|

|11|Preliminary positive|17|

All the help is greatly appreciated.

Thank you!