I took a different approach to this, and would love to hear some insights. Originally, I tried to summarize the combined data streams (grouped by transaction ID and concatenated by urgency and vendor) but i got stuck because my concatenated cells had multiple duplicates within each cell which made it hard for me to flag "N/A" and "Direct Deposit". So, what I did instead is create a filter to only show transaction IDs that are "Direct Deposit" and a vendor of "N/A", and used the unique tool to remove all duplicated transaction IDs.
Same answer, different process. Thoughts?
