S
stylaster
Hi All
I have data in column A1 to A2564. I want to take every other line
ie(A1, A3, A5, etc) and copy that to match the even columns in column
B. ie (A2 would go into B1, A4 would go into B3, etc.
So it is taking the value in every other line and copying it and
moving it up one cell and over one cell.
Thanks!
Roy
Example
A1 1
A2 2
A3 3
A4 4
Result
Al 1 B1 2
A2 now blank
A3 3 B3 3
A4 blank now
I have data in column A1 to A2564. I want to take every other line
ie(A1, A3, A5, etc) and copy that to match the even columns in column
B. ie (A2 would go into B1, A4 would go into B3, etc.
So it is taking the value in every other line and copying it and
moving it up one cell and over one cell.
Thanks!
Roy
Example
A1 1
A2 2
A3 3
A4 4
Result
Al 1 B1 2
A2 now blank
A3 3 B3 3
A4 blank now