ok table looks something like this...

Patient Num " Cancer " Asthma " Diabetes " COPD " 1 " 2 " 3 or more "
-----------------------------------------------------------------------------------------------------
1 y
2 y y
3 y y
4 y
5 y y y y


and I want


Patient Num " Cancer " Asthma " Diabetes " COPD " 1 " 2 " 3 or more "
-----------------------------------------------------------------------------------------------------
1 y 1

2 y y 2
3 y y 2
4 y 1

5 y y y y 4

and then i'll format it from there