Moving cells from one column to another

falcios

Active Member
Joined
Aug 30, 2006
Messages
279
Office Version
  1. 2019
Platform
  1. Windows
Hi tried to download XL2BB and I couldn't get it work. So I'm uploading an image of the issue

I have 12345 in column A, I want to move everything on the top of Column C. In the past, I counted the number of items in column A and either insert or shift down on Column C.

Now, is there an easier way to move contents from A to C, without counting, and make space for those items and move them over without overrriding cells.

Thanks in advance
 

Attachments

  • Moving Columns to Another - no space on top.png
    Moving Columns to Another - no space on top.png
    10.6 KB · Views: 10

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
I don't think your queston is quite clear to us (at least in looking at the image along with your explanation).
Can you show us a BEFORE and AFTER picture, along with a detailed explanation, explaining EXACTLY which rows to move and why?
 
Upvote 0

Forum statistics

Threads
1,214,650
Messages
6,120,736
Members
448,988
Latest member
BB_Unlv

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top