G
Gayle
Is there a way to move data from one column to another and have it
automatically update the row number by 1?
Example:
Move Col-A to Col-D
row 1 = BW1 row 1 = BW2
row 2 = BW43 row 2 = BW44
row 3 = BW85 row 3 = BW86
row 4 = BW127 row 4 = BW128
I'm not good at explaining what I want to do, so hopefully the example helps.
And it will certainly speed up the process as I'm now having to manually
change line by line and there are MANY lines.
automatically update the row number by 1?
Example:
Move Col-A to Col-D
row 1 = BW1 row 1 = BW2
row 2 = BW43 row 2 = BW44
row 3 = BW85 row 3 = BW86
row 4 = BW127 row 4 = BW128
I'm not good at explaining what I want to do, so hopefully the example helps.
And it will certainly speed up the process as I'm now having to manually
change line by line and there are MANY lines.