header | test | details |
a | alpha | 10 |
a | beta | 400 |
b | zoo | 32 |
b | gamma | 500 |
<tbody>
</tbody>
Hello there,
I have this spreadsheet starting in A1 with a header row. Then I have another row in row 2 ( a-alpha-10 in my example ), then one empty row every two rows. ( so row a-beta-400 is row 4). The last row is not known but the number of rows will never be more than 200 rows.
I need to copy row 2 into row 3, them copy row 4 into row 5, then row 6 into row 7 etc etc.
Additionally I need a condition to change the value of cell A. For example if value in cell A2 is "a" I need the value to be changed into "z" when copying it into A3. If the value in A2 is "z" I need the value copied in A3 to become "a". These will be the only 2 values possible.
I have failed to make this think work so far! Any hints? Many thanks