Is there a way to take the first occurrence in every value change in a column and re-write it with another value in the same row? For example:
<colgroup><col style="width:54pt" span="6" width="72"> </colgroup><tbody>
</tbody>
Column 1 | Column 2 | Column 6 | Column 7 | ||
apple | a | apple | a | ||
apple | a | pear | a | ||
apple | a | orange | b | ||
pear | a | grape | a | ||
pear | a | banana | b | ||
orange | b | apple | b | ||
grape | a | orange | a | ||
grape | a | ||||
banana | b | ||||
apple | b | ||||
apple | b | ||||
orange | a |
<colgroup><col style="width:54pt" span="6" width="72"> </colgroup><tbody>
</tbody>