Group tranposed data

[LousQuinn]

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 appear under the matching account. thanks

[#2]

Hi @LousQuinn 

With Power Query (sample attached):

[#3]

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)
)

[#4]

Thanks for both you answers

[#5]

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

[#6]

Ok will test both solutions asap. thanks again

[#7]

@LousQuinn 

Another 365 option

in I9:

=LET(
  JoinAmts, LAMBDA(Amounts,Accounts,account,
      TEXTJOIN(";",,FILTER(Amounts,Accounts=account))
  ),
  Accts, TRANSPOSE(UNIQUE(TBL_Source[Account])),
  StackedValues, REDUCE("",Accts,
    LAMBDA(seed,acct, VSTACK(seed,JoinAmts(TBL_Source[Amount],TBL_Source[Account],acct)))
  ),
  VSTACK(
    Accts,
    TRANSPOSE(IFNA(NUMBERVALUE(TEXTSPLIT(TEXTJOIN("|",TRUE,StackedValues),";","|")),""))
  )
)