+ Reply to Thread
Results 1 to 4 of 4

Help with converting table fields into a new table based on cell blank or not blank

  1. #1
    Forum Contributor
    Join Date
    08-08-2015
    Location
    North Carolina USA
    MS-Off Ver
    MS Office 2016
    Posts
    368

    Help with converting table fields into a new table based on cell blank or not blank

    HI, I need to create a new table that replicates the table I have, the thing is, I need the fields to be renamed to the correlated cell in column 1 for that row, if the cell is not blank. If it is blank, it should remain blank.

    Attached is an example.

    Thanks for any help!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    08-08-2015
    Location
    North Carolina USA
    MS-Off Ver
    MS Office 2016
    Posts
    368

    Re: Help with converting table fields into a new table based on cell blank or not blank

    Also - the actual table has a row that extends all the way out to column CO and has 1087 rows. they are all varying in length.

  3. #3
    Forum Contributor
    Join Date
    08-08-2015
    Location
    North Carolina USA
    MS-Off Ver
    MS Office 2016
    Posts
    368

    Re: Help with converting table fields into a new table based on cell blank or not blank

    any help??

  4. #4
    Forum Contributor
    Join Date
    08-08-2015
    Location
    North Carolina USA
    MS-Off Ver
    MS Office 2016
    Posts
    368

    Re: Help with converting table fields into a new table based on cell blank or not blank

    Disregard - i got it.

+ 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. LOOKUP TABLE -blank cell in the table array to return a figure
    By jonnops in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-28-2014, 09:08 AM
  2. [SOLVED] VLOOKUP - If table array is blank, need it to return blank
    By bxk006 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2014, 11:36 AM
  3. Pivot table in blank cells it says blank.... i want it empty
    By appell in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-27-2014, 09:43 AM
  4. Replies: 2
    Last Post: 11-22-2013, 02:52 PM
  5. Select table rows based on is not blank
    By reillc01 in forum Excel General
    Replies: 0
    Last Post: 12-02-2010, 11:22 AM
  6. How to "blank" pivot table calculated fields if result = 0
    By Joe in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2006, 01:45 PM
  7. [SOLVED] Pivot Table problem, blank fields aren't being added
    By Ant in forum Excel General
    Replies: 3
    Last Post: 11-07-2005, 11:15 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