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!