+ Reply to Thread
Results 1 to 10 of 10

Delete null cells in Power query

  1. 06-15-2022, 09:10 AM #1
    Undo
    Undo is offline
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    921

    Delete null cells in Power query

    Hello

    in appended query, looking to delete null cells ( don't delete entire rows) in query and shift cells up
    Attached Files Attached Files
    Last edited by alansidman; 06-15-2022 at 09:44 AM.
    Reply With QuoteRegister To Reply
  2. 06-15-2022, 09:49 AM #2
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,213

    Re: Delete null cells in Power query

    Please try

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
  3. 06-15-2022, 02:48 PM #3
    Undo
    Undo is offline
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    921

    Re: Delete null cells in Power query

    Thanks working but I am looking for steps after I append the tables, don't start from beginning and use main table
    because the data will be different not same, u will separate it by column name
    looking for custom situation
    Reply With QuoteRegister To Reply
  4. 06-15-2022, 03:12 PM #4
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,945

    Re: Delete null cells in Power query

    try this

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  5. 06-15-2022, 03:15 PM #5
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Delete null cells in Power query

    can't post the formula according to forum issues.

    See the attached file.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  6. 06-15-2022, 03:24 PM #6
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,213

    Re: Delete null cells in Power query

    Please try

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 06-16-2022, 02:25 AM #7
    Czeslaw
    Czeslaw is online now
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,298

    Re: Delete null cells in Power query

    Formullas
    unicate
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    value
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 06-16-2022, 09:13 AM #8
    Undo
    Undo is offline
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    921

    Re: Delete null cells in Power query

    Thanks all
    Bo_Ry #6
    Reply With QuoteRegister To Reply
  9. 06-19-2022, 08:59 AM #9
    Undo
    Undo is offline
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    921

    Re: Delete null cells in Power query

    May I know why power query is no read the code if its in upper case?
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  10. 06-19-2022, 02:01 PM #10
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,945

    Re: Delete null cells in Power query

    Power Query is case sensitive. All function keys must be according to the case. To see exact case, in a new query in the function line, type #share

    Also read the following: https://www.sqlbi.com/articles/lette...ula%20language.
    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. Query Editor to take value above if its Null
    By jp16 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-06-2022, 07:28 AM
  2. [SOLVED] Query that includes NULL values
    By dunnobe in forum Access Tables & Databases
    Replies: 4
    Last Post: 04-26-2018, 10:54 AM
  3. SQL: How do I replace NULL ( empty ) with zero in a sql query. For instance:
    By kbdb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-09-2018, 03:31 PM
  4. Concatenate Possibly null cells & delimiting semicolon, and delete ending semicolon if any
    By HopScotchNSoda in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-11-2013, 10:47 PM
  5. Macro Needed to delete range of cells based on null values in another cell
    By jeffmarsiglio in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2013, 08:22 AM
  6. [SOLVED] How can Access form run a query if field is not null?
    By jgomez in forum Access Tables & Databases
    Replies: 10
    Last Post: 01-14-2013, 02:35 PM
  7. How to delete rows that include blank/null cells
    By kostas in forum Excel General
    Replies: 5
    Last Post: 04-27-2007, 07:47 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1