+ Reply to Thread
Results 1 to 3 of 3

PQ add null rows

  1. #1
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    927

    PQ add null rows

    Hello

    how can I add two null rows in last step in my PQ table only if the table is empty data
    Attached Files Attached Files
    Last edited by Undo; 03-26-2023 at 10:32 AM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: PQ add null rows

    You may Count.Rows and if it's 0 add two null-filled rows, like for instance:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: PQ add null rows

    PS. If the column names in source are not known, or there are many columns in real table, you may use more universal solution and create null record with existing column names this way:

    Please Login or Register  to view this content.

+ 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. Index/match that skips null rows
    By kilohotel77 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-31-2016, 11:08 AM
  2. Count rows with multiple null and not null criteria
    By carlostheba in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2014, 05:16 AM
  3. [SOLVED] VBA to copy specific rows and stop when it found null rows
    By Khaled Diab in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-24-2014, 01:50 AM
  4. Hide all rows until first null row
    By Zach51215 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2013, 06:26 AM
  5. Delete rows with null values in two rows
    By fusion007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2011, 10:40 AM
  6. Replies: 11
    Last Post: 06-06-2011, 01:26 AM
  7. Dividing the sum of two rows ignoring null entries
    By dshigley in forum Excel General
    Replies: 2
    Last Post: 10-08-2008, 01:03 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