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.
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.