dknowles2004
Board Regular
- Joined
- Nov 15, 2004
- Messages
- 79
Please help!! I have a spreadsheet with two rows per product (hundreds of rows). I'm trying to move the values in the second row to Columns D and E of the preceding row. For example,
Rows 3 and 4. Move values in Row 4 to Row 3, Column D and E then delete Row 4. Obviously, each time the row is deleted, the references of the remaining rows will change!!
Then I need to repeat this for all the remaining rows.
Any ideas? I'm desperate.
Rows 3 and 4. Move values in Row 4 to Row 3, Column D and E then delete Row 4. Obviously, each time the row is deleted, the references of the remaining rows will change!!
Then I need to repeat this for all the remaining rows.
Any ideas? I'm desperate.