+ Reply to Thread
Results 1 to 2 of 2

Deleting blank cells in data set

  1. 08-16-2020, 11:16 PM #1
    hollacost69
    hollacost69 is offline
    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
    Reply With QuoteRegister To Reply
  2. 08-16-2020, 11:30 PM #2
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,452

    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
    Quang PT
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1