Swapping Columns
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
|