Forum Discussion

RanzieJ's avatar
RanzieJ
Copper Contributor
Sep 19, 2023

How to split table?

Hi , can i ask for help? is there a way or formula that can split tables with filter? Like this for example? From this : To This : Or if possible, separate them by "LEVEL" into separat...
excel
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Sep 19, 2023

RanzieJ 

If you had 365, you could create a simple function to pull certain records from the table.

 

 

'SplitTable Lambda
=LAMBDA(level,LET(
    header, Table1[#Headers],
    filtered, SORT(FILTER(Table1, Table1[Level] = level, ""), {1, 2}),
    VSTACK(header, filtered)
))

 

 

Then call the function where needed in a sheet:

 

Unfortunately, Excel 2019 does not support dynamic arrays nor Lambda.  It's still possible with a ctrl+shift+enter array (INDEX-SMALL) but it's not an elegant solution.  Using the Advanced Filter might be a better way to go in 2019.

Resources