Swapping Columns
Eduardo,
That's just it, i dont' want to do this manually. My luck, in the past, has
shown that some how some way, I do something wrong.
"Eduardo" wrote:
Hi Penny,
to swap columns just select lets's say column C, right click in the mouse,
cut, select
no column B, right click paste
If this helped please click yes
"mePenny" wrote:
I have a list of vehicles with license plate and key number, all having there
own column. Is there a formula where B & C, F & G, J & K will swap places?
(would like to see key, plate, vehicle, assigned, ect..)
B = Plate #
C = Key #
D = Vehicle
E = Where vehicle is assigned
F = Plate #
G = Key #
H = Vehicle
I = Where vehicle is assigned
J = Plate #
K = Key #
L = Vehicle
M = Where vehicle is assigned
Thank you in advance for the help.
Penny
|