+ Reply to Thread
Results 1 to 3 of 3

Looking for the best way to condense table with blanks

  1. #1
    Forum Contributor
    Join Date
    11-01-2013
    Location
    Atlanta, GA USA
    MS-Off Ver
    Excel 2010
    Posts
    115

    Looking for the best way to condense table with blanks

    We have a large 5-column table that contains many blank-rows scattered through the list.

    We want to condense the table to a new table (on the same worksheet) with no blank rows. Each row that has data has it in all 5 columns. The first column is a date.

    So we'd like the new table to be A1:E1250 while the old table moves over to G1:K1675.

    Thank you for the help!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,245

    Re: Looking for the best way to condense table with blanks

    Since you have not provided a sample worksheet to test, this code is untested. Please advise if there are issues.

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    11-01-2013
    Location
    Atlanta, GA USA
    MS-Off Ver
    Excel 2010
    Posts
    115

    Re: Looking for the best way to condense table with blanks

    Alan, thank you for your solution. We're NEWBIE's at Excel, so code is a stretch for us, but we're going to try to make it work.

    Thank you for your help! Very much appreciated!

+ 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. multidimensional index and match function to condense table
    By Kamleshsoni in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-14-2013, 04:32 PM
  2. Condense list of data that contains some blanks to just a list of data
    By joemsimth in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-09-2013, 10:48 AM
  3. Pivot table with blanks
    By timlocke in forum Excel General
    Replies: 4
    Last Post: 07-15-2011, 02:19 PM
  4. Condense multiple rows into a table view
    By Jonsocks in forum Excel General
    Replies: 3
    Last Post: 06-09-2010, 09:47 AM
  5. Get Pivot Table To Ignore Blanks
    By StevenAFC in forum Excel General
    Replies: 2
    Last Post: 09-11-2007, 05:06 AM

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