Forum Discussion

Akivabuckman's avatar
Akivabuckman
Copper Contributor
Sep 05, 2022

Vertical Slicers

2 dimensional slicers sort left to right, then next line, then left to right, etc. Anyone know how to make it sort as shown below: vertically down, then a column over, then vertically down aga...
excel
dscheikey's avatar
dscheikey
Bronze Contributor
Sep 07, 2022

Akivabuckman 

Now is the time! TOCOL() and WRAPCOLS() have just been unlocked for me in Excel for the Web.

=WRAPCOLS(SORT(TOCOL(A1:C4,1)),ROWS(A1:C4),"")

 This is how simple the formula can look with the new possibilities.

Resources