+ Reply to Thread
Results 1 to 3 of 3

Extracting Only Non-Blanks

  1. #1
    Registered User
    Join Date
    11-07-2018
    Location
    Minnesota
    MS-Off Ver
    Office 365 ProPlus Version 1708
    Posts
    6

    Extracting Only Non-Blanks

    Hello all,

    I am searching for a formula that will only extract the non-blank cells within a column. I would like to extract the non-blanks in column X and place them in column Y as below. An example of my data is below

    X Y
    - 1234
    - 1235
    1234 1236
    1235 1237
    1236 1238
    - ...
    1237
    -
    1238
    ...

    If there is not a formula but an easier way that would be great too. Thank you for your help.
    Last edited by spudder6; 11-20-2018 at 12:28 PM. Reason: Added sample file

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Extracting Only Non-Blanks

    will you define non blanks? Are you looking for cells that contain values? What if there is a formula but the cell shows no values? Are you asking for non-null values. Please clarify. You might be better served if you upload a sample worksheet with before and after scenarios to make sure we understand what you mean by non-blank
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Extracting Only Non-Blanks

    Sure you can do this with a formula but here's a simpler way:

    Copy and paste column X into column Y > with column Y selected go to Find & Select > Go To Special > Blanks > OK

    Now right-click on any of the selected cells > Delete > Shift cells up

+ 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. [SOLVED] Formula to count blanks and non-blanks with a dynamic range
    By brittdyer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-12-2018, 07:45 AM
  2. Replies: 9
    Last Post: 05-22-2018, 10:37 AM
  3. BLANKS (Not Really Blanks) AND Rearrange ignoring blanks
    By shivspatil in forum Excel General
    Replies: 4
    Last Post: 02-02-2018, 08:28 AM
  4. [SOLVED] Access Query shows (Blanks) but no blanks in data!
    By MissDB in forum Access Tables & Databases
    Replies: 0
    Last Post: 09-08-2016, 07:16 AM
  5. VBA code finds blanks, but how to write VBA to ignore non blanks?
    By hopegriffin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2016, 10:51 AM
  6. [SOLVED] How to convert a horizontal vector with blanks into a vertical one without blanks
    By luv2glyd in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-27-2014, 02:55 PM
  7. [SOLVED] Paste Special Skip Blanks not skipping blanks, but overwriting...
    By gsrosin in forum Excel General
    Replies: 0
    Last Post: 02-22-2005, 12:06 AM

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