I have a simple spreadsheet that has a large volume of data structured as such;

  • Going down several thousand rows.

I'd like to move all of column B into the blank cells of column A, keeping the same rows, so the data would become;

A1   A2   A3   A4

Is there a simple way of doing this? When moving the data it overwrites everything in column A

  • try to Record a Macro and post your code here. Explain what does not work the way you want and your attempts to fix it. – user222864 Aug 15 '13 at 8:47

There is an option to do this with Paste Special. Just select column B, then right click column A and select Paste Special... > Paste Special... so that you get a pop up window with a lot of radio buttons in it. There is an option at the bottom "skip blanks" which does what you need. Activate this option and click ok.

  • Highlight and copy the desired data (horizontal or vertical).
  • Left click the desired location to copy the data to.
  • Right click >> Paste special.
  • There are options there like skip blanks or transpose which may be useful.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy