Forum Discussion
Group tranposed data
Hello, I'm having difficulty 'grouping' the transposed data - so as attached, if the account in colum A matches/is the same, rather than creating separate transposed colums, all amounts will appe...
Hi LousQuinn
A 365 alternative assuming you have functions HSTACK & VSTACK:
In I3:
=LET(
Header, TRANSPOSE(UNIQUE(TBL_Source[Account])),
StackAmt, REDUCE(0,Header,
LAMBDA(seed,acct, HSTACK(seed, FILTER(TBL_Source[Amount],TBL_Source[Account]=acct)))
),
Clean, IFNA(DROP(StackAmt,,1),""),
VSTACK(Header, Clean)
)