Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question

migrated from Aug 15 '13 at 10:01

This question came from our site for professional and enthusiast programmers.

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.

share|improve this answer
Awesome thanks!! – user2646560 Aug 15 '13 at 8:58
@User2646560 if this answered your question you should mark it as the answer. – Kevin Anthony Oppegaard Rose Aug 15 '13 at 10:19
  • 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.
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.