Moving values in columns with formula

I

irpanch

New member
Joined
Feb 6, 2016
Messages
5
Reaction score
0
Points
0
Hi

i wonder if there any formula or macro that automatically moving values in a column under it's column.
for example i have a data with 11 columns (Date,Jan,Feb..Okt. *i attach the example of my data) and i want to move the columns on Feb under the Jan Column. and then i want to move the March Column under Jan column and so on. All i can do right now is just use manually copy-paste the values. but it's frustating when i work in large database.
any solution? thx in advance.
 

Attachments

  • SORTING COLUMN.xlsx
    9.7 KB · Views: 18
If you have to repeat this operation on a regular basis you could record a macro that

or moves the ranges as required
or replaces the column titles as required then applies a sorting by columns ( maybe you'll have to add the tool to your ribbon)
 
thank you for your quick respond. i'll try it
 
cross post link

sorry. how do i fixed it. can't find edit my post here
 
You must log in or register to reply here.
Back
Top