Hi all,
I have to columns of data and I am looking to copy the first non blank value and move it to the adjacent cell. The raw data looks like this:
<tbody>
</tbody>
In the first instance I would like to copy -3 in the 2nd column and paste it under the -2 in the first column.
Then copy the 2 in the first column (2nd set of rows) and paste it underneath the 1 in the first set of data in the 2nd column.
And so on (for a variable number of times)
Below I have highlighted the values in the above example:
<tbody>
</tbody>Many thanks!
I have to columns of data and I am looking to copy the first non blank value and move it to the adjacent cell. The raw data looks like this:
-1 | |
0 | |
-1 | |
-2 | |
-3 | |
-2 | |
-1 | |
0 | |
1 | |
2 | |
3 | |
4 | |
3 | |
4 | |
5 | |
4 | |
3 | |
2 | |
1 | |
0 | |
1 | |
0 | |
1 |
<tbody>
</tbody>
In the first instance I would like to copy -3 in the 2nd column and paste it under the -2 in the first column.
Then copy the 2 in the first column (2nd set of rows) and paste it underneath the 1 in the first set of data in the 2nd column.
And so on (for a variable number of times)
Below I have highlighted the values in the above example:
<tbody> </tbody> | |||||||||||||||||||||||||||||||||||||
<tbody>
</tbody>