Forum Discussion

Zaibass81's avatar
Zaibass81
Icon for Helper I rankHelper I
5 years ago
Solved

Remove top null rows of each columns

Hello,

I am looking for some help or advice on how to remove  null values from each row to align to the first column 

 

 

 

Need Help
  • Jakinta's avatar
    Jakinta
    5 years ago

    Hi,

     

    You can FillUp all columns except Column1, then filter out nulls on Column1.

2 Replies

  • Jakinta's avatar
    Jakinta
    Icon for Solution Sage rankSolution Sage
    5 years ago

    Hi,

     

    You can FillUp all columns except Column1, then filter out nulls on Column1.

    • Zaibass81's avatar
      Zaibass81
      Icon for Helper I rankHelper I
      5 years ago

      Thanks! did the trick:) had a similar idea, but because I was doing it including Column 1 didn't get the expected result