+ Reply to Thread
Results 1 to 2 of 2

Trying to copy non-blanks from one column to the blanks of the column next to it????

  1. #1
    Registered User
    Join Date
    08-13-2012
    Location
    Milwaukee, WI
    MS-Off Ver
    Excel 2003
    Posts
    4

    Question Trying to copy non-blanks from one column to the blanks of the column next to it????

    Hello All,

    I have an excel spreadsheet that I have filtered to show everthing except for blanks in a column. I'm trying to copy and paste the non-blanks into the column next to it. When I try to do this, I overwrite what is already in the column that I'm trying to paste. Does anyone have any tricks/hints on how to do this?

    Thank you.

  2. #2
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: Trying to copy non-blanks from one column to the blanks of the column next to it????

    How about turning off the filter first and turn it on after pasting the information in the column next to it?
    Click on star (*) below if this helps

  3. #3
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Trying to copy non-blanks from one column to the blanks of the column next to it????

    I *think* I understand...

    With these two lists In A1:B21:
    Please Login or Register  to view this content.
    This technique will copy the non-blank Col_A cells and paste them into the blank Col_B gaps
    • Select and copy A1:A21
    • Select B1
    • Home.Paste.Paste_Special...check: Skip Blanks...Click: OK

    The end result will be:
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  4. #4
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Trying to copy non-blanks from one column to the blanks of the column next to it????

    No additional comment...My post isn't displaying in the listing so I'm just trying to trigger a change with this new post

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1