So my data looks like this.
y1999q1 y1999q2 y1999q3 y1999q4
US_a
US_b
US_c
CH_a
CH_b
CH_c

I want to create observations (US and CH) so that they are the sum of three observations. Intuitively, I want to make US = US_a + US_b + US_c. How do I do this?

The actual dataset is extremely large and with many different ids for the observations.