Swapping Columns

M

mePenny

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
 
E

Eduardo

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
 
M

mePenny

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top