Group tranposed data

Question

Hello,&nbsp;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 appear under the matching account. thanks&nbsp;&nbsp;

lorenzo · Answer

Hi&nbsp;LousQuinn&nbsp;&nbsp;With Power Query (sample attached):&nbsp;

lorenzo · Answer

Hi&nbsp;LousQuinn&nbsp;&nbsp;A 365 alternative assuming you have functions HSTACK &amp; VSTACK:&nbsp;&nbsp;In&nbsp;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)
)

lousquinn · Answer

Thanks for both you answers

lorenzo · Answer

You're welcome. If any of them does what you expect please mark it as solution to help those who search this site - Thanks &amp; nice day...

lousquinn · Answer

Ok will test both solutions asap. thanks again

Forum Discussion

Group tranposed data

Share

Resources