Hi, I tried figuring this out with old posts but nothing so far has worked. I would like to get the bottom two colums into the single one beneath it. hhid is a string while hvidx is not. How do I do this? Do I first have to destring or is there an easy direct command?
Thanks for your help!

hhid hvidx
1 12 1
1 20 1
1 20 2
1 20 3
1 20 4
1 20 5
1 20 6
1 27 1
1 27 2
1 27 3

caseid
1 12 1
1 20 1
1 20 2
1 20 3
1 20 4
1 20 5
1 20 6
1 27 1
1 27 2
1 27 3