Sample data:

```
A B C D
1 .05 .05 .90 A1
2 .05 .10 .85 B1
3 .05 .15 .80 C1
4 .05 .20 .75 A2
5 .05 .25 .70 B2
6 .05 .30 .65 C2
7 .05 .35 .60 A3
8 .05 .40 .55 B3
9 .05 .45 .50 C3
```

I am trying to take the information in the first three columns and copy it to the fourth column so that in the fourth column I include A1 to C1, then A2 to C2, then A3 to C3, and so on. Is there any way to automate this?