Consider the following excel worksheet:

```
| ... | H | I | J
--+-----+--------+------+-----
1 | ... | obsDay | obs3 | obs4 ...etc
--+-----+--------+------+-----
2 | ... | 3 | |
--+-----+--------+------+-----
3 | ... | 4 | |
--+-----+--------+------+-----
4 | ... | 8 | |
--+-----+--------+------+-----
```

In `A2`

to `A148`

I have 147 `obsDay`

values. I now need to make a separate column for each value. The values in cell `B1`

and `C1' are respcetively there because of the formulas`

="obs"&A2`and`

="obs"&A3`

My question is: I cannot drag the formula to all other 145 columns. I I would drag the formula of `B1`

to the right, `C1`

gets value `obs`

, with underlying formula `="obs"&B2`

. I know I can fix column a like his: `="obs"&$A2`

, but if I thne drag it to the right, `C2`

gets value 'obs3' as well (with formula `="obs"&$A2`

underlaying), while I need it to be `="obs"&$A3`

, then `="obs"&$A4`

, `="obs"&$A5`

, etc..

What am I doing wrong?