Forum Discussion

cdavison's avatar
cdavison
Copper Contributor
Jun 25, 2026

HELP WITH EXCEL

Struggling to do a simple transition in Excel if anyone can give some advice:   I have 3 items I need to run up & down instead of across... is there any easy way ??? So I need the Name and two of t...
excel
Formulas and Functions
IlirU's avatar
IlirU
Iron Contributor
Jun 27, 2026

Hi cdavison​,

Try below formula in an empty cell:

=LET(
     name, A1:Z1,
        x, A2:Z2,
           TEXTSPLIT(TEXTJOIN(";",, BYROW(GROUPBY(TRANSPOSE(SCAN("", name, LAMBDA(a,b, IF(b = "", a, b)))),
                     TRANSPOSE(IF(x = "", "", x)), ARRAYTOTEXT,, 0), ARRAYTOTEXT)), ", ", ";", TRUE,, "")
)

HTH

IlirU