Is there a way to 'collapse' columns with the same name? For instance
Week State Temp Precip State Temp Precip
1 AL 85 2 LA 95 6
2 AL 85 2 LA 95 6
3 AL 85 2 LA 95 6
4 AL 85 2 LA 95 6
And what I want to end up with is
Week State Temp Precip
1 AL 85 2
2 AL 85 2
3 AL 85 2
4 AL 85 2
1 LA 95 6
2 LA 95 6
3 LA 95 6
4 LA 95 6
I have tried a variety of functions and methods but nothing has worked so far.
