Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

A1
   B2
      A3
         B4
  • 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 stackoverflow.com 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. –  me how Aug 15 '13 at 8:47

2 Answers 2

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

 
discard

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