Results 1 to 4 of 4

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

Threaded View

  1. 01-14-2016, 02:55 PM #1
    BG1983
    BG1983 is offline
    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
    Reply With QuoteRegister To Reply
« 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. 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. How remove zero values representing blank cells from original table connected to new table
    By _Rapier_ in forum Excel Charting & Pivots
    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. 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1