+ Reply to Thread
Results 1 to 5 of 5

Help! Moving selective data

  1. #1
    Registered User
    Join Date
    03-09-2016
    Location
    Somerset
    MS-Off Ver
    7
    Posts
    4

    Help! Moving selective data

    Hi all,

    I'm hoping someone is able to help as I am at a dead end.

    I have a spreadsheet of 23,000 lines in two columns of data. Column A has data in every cell and Column B has data in a selection of cells, the others being blanks.
    What I need to do is merge the data so those cells in colum B that hold data overwrite/update those in colum A, but the cells in column B that are blank don't overwrite the existing data in Column A

    I am sure there's a formula pattern or an IF function but I just can't work it out.

    Thanks in advance for any help!

  2. #2
    Forum Contributor
    Join Date
    01-06-2015
    Location
    Huntsville, AL
    MS-Off Ver
    Office 365
    Posts
    178

    Re: Help! Moving selective data

    I would create a 3rd column C. Type this in and drag down.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Then I would copy Column C and paste the values in Column A.

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,849

    Re: Help! Moving selective data

    Highlight the cells in column A and B, then press the F5 (GoTo) key, click on Special, then on Blanks and OK. Then begin to enter a formula by typing =, and then click on the cell immediately to the left of the active cell, and then do CTRL-Enter. All the blank cells in column B will be filled with the corresponding values from column A. You can then fix the values in column B so as to remove the formulae, and then you can delete column A.

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    03-09-2016
    Location
    Somerset
    MS-Off Ver
    7
    Posts
    4
    Quote Originally Posted by Chris McGlothen View Post
    I would create a 3rd column C. Type this in and drag down.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Then I would copy Column C and paste the values in Column A.
    Thanks Chris

  5. #5
    Registered User
    Join Date
    03-09-2016
    Location
    Somerset
    MS-Off Ver
    7
    Posts
    4
    Quote Originally Posted by Pete_UK View Post
    Highlight the cells in column A and B, then press the F5 (GoTo) key, click on Special, then on Blanks and OK. Then begin to enter a formula by typing =, and then click on the cell immediately to the left of the active cell, and then do CTRL-Enter. All the blank cells in column B will be filled with the corresponding values from column A. You can then fix the values in column B so as to remove the formulae, and then you can delete column A.

    Hope this helps.

    Pete
    Pete, That was just the job! Perfectly done in a few seconds, saving me hours of work. THANKS

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 12-11-2012, 05:04 AM
  2. [SOLVED] Selective drop down data depending on target cells' data - Help
    By stiganovski in forum Excel General
    Replies: 2
    Last Post: 04-17-2012, 09:35 PM
  3. Listing of selective data
    By peri1224 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-23-2011, 10:07 PM
  4. Selective moving data
    By Dutchera in forum Excel General
    Replies: 3
    Last Post: 11-02-2010, 02:51 PM
  5. keeping selective data
    By minti in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2007, 02:08 AM
  6. Selective Data
    By MattD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2005, 03:05 PM
  7. [SOLVED] Moving selective data from one sheet to anouther
    By handymanmd in forum Excel General
    Replies: 1
    Last Post: 09-07-2005, 11:05 PM

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