Shift cells up

Dear Experts, I have a data like below:- and want to delete all the nulls,( shift) all the empty cells up, I can do this using F5-> special , select blank and delete , but with h...

shiftcellsup.xlsx2.2 MB

BI & Data Analysis

excel

Formulas and Functions

power bi

djclements

Aug 10, 2025

A formula approach:

=WRAPROWS(TOCOL(_0xB8D8_Log_Study_Sample,1),3)

Or Power Query:

let
    Source = Excel.CurrentWorkbook(){[Name="_0xB8D8_Log_Study_Sample"]}[Content],
    #"Filled Down" = Table.FillDown(Source,{"Custom", "Custom.1"}),
    #"Filtered Rows" = Table.SelectRows(#"Filled Down", each ([Custom.2] <> null))
in
    #"Filtered Rows"

djclements

Bronze Contributor

Aug 10, 2025

A formula approach:

=WRAPROWS(TOCOL(_0xB8D8_Log_Study_Sample,1),3)

Or Power Query:

let
    Source = Excel.CurrentWorkbook(){[Name="_0xB8D8_Log_Study_Sample"]}[Content],
    #"Filled Down" = Table.FillDown(Source,{"Custom", "Custom.1"}),
    #"Filtered Rows" = Table.SelectRows(#"Filled Down", each ([Custom.2] <> null))
in
    #"Filtered Rows"

anupambit1797
Iron Contributor
Aug 10, 2025
WRAPROWS, is really Magical.. Thanks for the formula.

Forum Discussion

Shift cells up

Resources