Forum Discussion
Dazzathedrummer
Jun 26, 2024Copper Contributor
Trying to create a 'one cell' table using dynamic arrays...
Hi, I'm trying to create a summary table using dynamic arrays for a budget document - the idea is that the table picks up any changes in data that the budget holder makes . I started out by just...
Lorenzo
Jul 03, 2024Silver Contributor
Not sure this is what you expect (if not provide a picture of the expected result):
With data formatted as table named Table1:
=LET(
StackCat, LAMBDA(init,type,
VSTACK(init, type, FILTER(Table1, Table1[Type] = type), "")
),
array, DROP( DROP( REDUCE(0,UNIQUE(Table1[Type]), StackCat), 1), -1),
kcols, SEQUENCE(,COLUMNS(array)),
IFNA( FILTER(array, IF(kcols = 2, 0, kcols)), "")
)- DazzathedrummerJul 05, 2024Copper ContributorThanks - I'll check that out!