Hi.
I have the following variables from a subset data:
Obs A1 A2 A3 B1 B2 B3 C1 C2 C3 ....
1
2
3
4
5
How do I merge all A variables to become one column, similarly for B and C?
Some rows maybe totally empty e.g. (Row 3) . How do I exclude such rows in the code?
The output will look like:
Obs A B C ....
1
2
4
5
1
2
4
5
1
2
4
5
Thank you.