Is there a way to move the row of Excel directly to the last blank?

Help Activities
, ,
1

image

2.xlsx (8.6 KB)

I’d like to fill it out after arriving at the part marked with < - - -

I tried to use the counter system, but this method is too slow.

2

Hi @kanmz
did you meant you need to fill it with value 2 ?

3

hello, my friends @NIVED_NAMBIAR

It’s an example, so it doesn’t have to be filled with 2

4

So what u need to fill there ?

5

I’m going to fill it up with strings.

6

would it be constant in all the cells?

7

svsvfsvf
gdfgdgb
It’s Aspa.
It’s Aspaf.
a four-sided by the four waves

This is how it’ll be written. XD

8

Hi @kanmz ,

Try below steps,

  1. Read the Excel
  2. Apply filter as columnName != “”
  3. TotalRow = Count the filtered data rows
  4. TotalRow+1 will be the next empty row
9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.