ASTACK

=ASTACK(a,w)

a
array
w
width of stack

ASTACK stacks an array.

Xlambda

Well-known Member
Joined
Mar 8, 2021
Messages
860
Office Version
  1. 365
Platform
  1. Windows
ASTACK stacks an array, calls AUNSTACK
Excel Formula:
=LAMBDA(a,w,
    LET(k,ABS(w),
       IF(k>=COLUMNS(a),a,TRANSPOSE(AUNSTACK(TRANSPOSE(a),k)))
    )
)
LAMBDA 5.0.xlsx
ABCDEFGHIJKLMNOPQRS
1123456789101112131415161718
2192021222324252627282930313233343536
3373839404142434445464748495051525354
4
5
66123456512345
71920212223241920212223
83738394041423738394041
9789101112678910
102526272829302425262728
114344454647484243444546
121314151617181112131415
133132333435362930313233
144950515253544748495051
15161718
16343536
17525354
18
Sheet6
Cell Formulas
RangeFormula
A1:R3A1=SEQUENCE(3,18)
C6:H14C6=ASTACK(A1#,B6)
K6:O17K6=ASTACK(A1#,J6)
Dynamic array formulas.
 
Upvote 0

Forum statistics

Threads
1,223,575
Messages
6,173,148
Members
452,502
Latest member
PQCurious

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top