Forum Discussion

Jayanta85's avatar
Jayanta85
Copper Contributor
Jun 06, 2023

Autofill data from in excel

  I have 9 column and several rows but i have less value in the same rows. I need to fill the data from R1, R2, R3 if have more then R4. But if R value in first row is blank and I need to ...
Formulas and Functions
Lorenzo's avatar
Lorenzo
Silver Contributor
Jun 07, 2023

Jayanta85 

In attached file added a 365 option:

 

With data in table TableIn:

=IFNA(
  VALUE(
    TEXTSPLIT(
      TEXTJOIN(";",,BYROW(TableIn, LAMBDA(rw, TEXTJOIN(",",,rw)))),
      ",",";"
    )
  ),
  ""
)

Resources