2

I want to copy and paste the non-blank numbers from value 2 to value 1, but I can't paste on the same row number

Image attached

  • 1
    Welcome to Super User. You may still get additional answers. If an answer solves the problem for you, consider accepting it (click the checkmark next to it). That helps other users by identifying that there is a proven solution here, and also awards a little rep to both of you for the effort. – fixer1234 May 15 '18 at 9:43
6

You need to use Paste Special:

Copy the data you want, and get ready to paste. But instead of doing a normal paste, select the little button under "Paste" (on the "Home" tab in the ribbon) and select "Paste Special"

Check the box that says "Skip blanks"

enter image description here

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.