How to use Multi-row tool

[ktberger_2020]

I have something like the below data where I want to be able to identify any agreement numbers that have a transactiontypeid of both 19 and 28 (they don't have to be in sequence).  Where I would like a result similar to the 2nd table.

I cannot figure out how to use the multi-row tool to make that happen. Can someone please show me the way?

SourceStore	AgreementNumber	TransDate	TransactionTypeId
C0304	43005	8/1/2023	1
C0304	43005	8/1/2023	10
C0304	43005	8/2/2023	34
C0297	50170R	1/16/2024	30
C0818	26291	10/3/2023	18
C0818	26291	11/11/2023	3
C0818	26291	9/13/2024	28
C1181	15876	8/30/2024	9
C1181	15876	11/13/2024	19
C1181	15876	8/30/2024	9
C1181	15876	11/22/2024	28
C0240	E2392762	12/31/2022	1
C0240	E2392762	1/5/2023	34
C0240	E2392762	9/14/2023	10
C0452	26809	4/5/2023	1
C0452	26809	4/5/2023	34
C0452	26809	6/28/2024	9
C0452	26809	11/13/2024	19
C0452	26809	11/21/2024	28
C0452	26809	11/21/2024	8

SourceStore	AgreementNumber	TransDate	Has19and28
C0304	43005	8/1/2023	No
C0297	50170R	1/16/2024	No
C0818	26291	9/13/2024	No
C1181	15876	8/30/2024	Yes
C0240	E2392762	9/14/2023	No
C0452	26809	4/5/2023	Yes

[rfoster7 · Accepted solution]

You don't need a multi row tool for this. You can just use a formula tool and group by tool. I'm not 100% if you are using the min(transaction date) or not for your third column? Looks like you are. 

[CoG · Accepted solution]

For learning, this problem can be solved with the Multi-Row Formula Tool like so, although @rfoster7 has provided a perfectly good solution as well:

Hope this helps and Happy Solving!

[ktberger_2020]

Thanks, this helped me see things in a different perspective than the way that I thought it should be.

[ktberger_2020]

Thank you. This helps me understand how to use the multirow tool.