|
In response to
"I need remedial help in Excel for stacking columns (because it's so needlessly more complex than Google sheets)"
by
Max
|
found a workable solution, though I think it's stupidly wordy compared to Google Sheets
Posted by
Max
Oct 13 '21, 14:16
|
how is there not a function that simply allows =STACK(range1,range2,...) ???
=LET(
rows1,ROWS(r.1),
rows2,ROWS(r.2),
cols1,COLUMNS(r.1),
rowindex,SEQUENCE(rows1+rows2),
colindex,SEQUENCE(1,cols1),
IF(
rowindex<=rows1,
INDEX(r.1,rowindex,colindex),
INDEX(r.2,rowindex-rows1,colindex))
|