*Bounty: 50*

*Bounty: 50*

I have three columns:

- Column A contains a count from 1 to 100, representing different sample stations
- Column B contains numbers from column a (values between 1 to 100) but not all of them because I get a list with data from only some of the stations each time
- Column C contains data associated with column B, for example a temperature reading at the sampling station or any other information

Now I would like to avoid to copy all information manually from Column C to where it belongs in Column A. I want to arrange column B in such a way that the number reflects the one in column A with empty spaces in column B when necessary. Afterwards column B can be eliminated.

As an example:

```
ColumnA, ColumnB, ColumnC
1,1,a
2,2,d
3,4,r
4,6,e
5,7,x
6,9,r
7,10,e
8,11,f
9,13,e
10,15,e
...,...,...
```

Should afterwards look like this …

```
ColumnA, ColumnB, ColumnC
1,1,a
2,2,d
3,
4,4,r
5,
6,6,e
7,7,x
8,
9,9,r
10,10,e
11,11,f
12,
13,13,e
14,
15,15,e
...,...,...
```

I’m pretty sure I did this a couple of years ago but now have forgotten. Any answer is much appreciated!