Forum Discussion
dkingsbury
Apr 26, 2022Copper Contributor
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 ...
Lorenzo
Apr 26, 2022Silver Contributor
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 <> "")
)dkingsbury
Apr 27, 2022Copper Contributor
Thanks! This works well!
- LorenzoApr 27, 2022Silver ContributorWelcome. Glad I could help
There's a link to mark solutions (can help those who search this site...)