Combine two working formulae using BYROW (or other function(s))

[TMS]

Short story: I have two formulae that work to provide a solution. It would be more aesthetically pleasing (to me) if these could be combined into one formula.

Long story ...

I am working on a solution for a user and I have two formulae that, together, provide a complete answer. I would like to combine the two formulae using BYROW but I just can't get it to work.

The two formulae are ...

In A2:

Please Login or Register  to view this content.

In B2:

Please Login or Register  to view this content.

I've added the first formula into the second so the data is available ...

In A12:

Please Login or Register  to view this content.

I thought I should be able to drop in a BYROW and reference the variable "u" as the range. But I am struggling to get it to work.

Sample file attached

Original thread: Index Match Min/Max!?!?

Your thoughts, advice and assistance would be most welcome.

[Bo_Ry]

Please try

=LET(z,PaymentActivityT,n,INDEX(z,,2),pw,INDEX(z,,8),un,UNIQUE(n),m,INDEX(un,3),c,{7,6,12,13},b,{4,17},am,SUMIFS(INDEX(z,,4),n,un,pw,{" p*"," w*"}),
DROP(REDUCE(0,un,LAMBDA(a,u,LET(f,FILTER(z,(n=u)*(pw=" Payment")),lt,TAKE(f,-1),ft,TAKE(f,1),tr,TOROW(VSTACK(INDEX(lt,c),INDEX(ft,c)),,1),
VSTACK(a,HSTACK(u,INDEX(lt,b),INDEX(ft,b),IF(tr=" ","N/A",tr),XLOOKUP(u,un,am)))))),1))


BYROW only generates 1 column result.

[Bo_Ry]

Better and shorter one

=LET(z,PaymentActivityT,pw,INDEX(z,,8),p,FILTER(z,pw=" Payment"),n,INDEX(p,,2),un,UNIQUE(n),l,XMATCH(un,n),f,XMATCH(un,n,,-1),
h,HSTACK(INDEX(p,HSTACK(f,f,f,l,l,f,l,f,l,f,l,f,l),{2,4,17,4,17,7,7,6,6,12,12,13,13}),SUMIFS(INDEX(z,,4),INDEX(z,,2),un,pw,{" p*"," w*"})),IF(h=" ","N/A",h))