Forum Discussion

Copper Contributor

Apr 26, 2022

Create a list from an existing list in excel

I have a table with non-numerical values that are being populated from an if/index formula. For example, I have the following set of data: Hello This is This my ...

excel

Lorenzo

Silver Contributor

Apr 26, 2022

dkingsbury

Assuming Excel 2021 or 365:

in E2:

=LET(
    rws,    ROWS(MyRange),
    seqK,   SEQUENCE( rws * COLUMNS(MyRange),,0 ),
    seqR,   1 + MOD(seqK, rws),
    seqC,   1 + QUOTIENT(seqK, rws),
    stack,  INDEX(MyRange, seqR, seqC),
    FILTER(stack, stack <> "")
)

StackRangeRemoveFalseBlanks.xlsx18 KB

dkingsbury

Copper Contributor

Apr 27, 2022

Thanks! This works well!

Lorenzo
Silver Contributor
Apr 27, 2022
Welcome. Glad I could help
There's a link to mark solutions (can help those who search this site...)