+ Reply to Thread
Results 1 to 2 of 2

Deleting blank cells in data set

  1. #1
    Registered User
    Join Date
    02-14-2020
    Location
    Hoboken
    MS-Off Ver
    2019
    Posts
    21

    Deleting blank cells in data set

    I have a table of data where I am wanting to remove all of the blanks and have all of the numbers in each column be in consecutive order. What is the best way to approach this?
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,274

    Re: Deleting blank cells in data set

    I export the table into range J:Q with consecutive list
    J2:
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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] Deleting a range of blank cells
    By maym in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-12-2018, 02:36 AM
  2. CONCATENATE data in row but deleting blank cells
    By a0d613 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-18-2013, 12:34 PM
  3. deleting blank cells
    By bostonguy in forum Excel General
    Replies: 2
    Last Post: 01-31-2012, 11:47 AM
  4. Excel 2007 : deleting blank (or zero) cells in macro
    By dcincala in forum Excel General
    Replies: 4
    Last Post: 10-18-2010, 12:46 PM
  5. Deleting blank cells
    By Cononach in forum Excel General
    Replies: 4
    Last Post: 06-02-2007, 05:27 PM
  6. Deleting Blank Cells Wholesale?
    By Trey in forum Excel General
    Replies: 1
    Last Post: 10-06-2005, 05:05 PM
  7. [SOLVED] Deleting blank cells
    By savbci in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2005, 02:06 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