Removing contra entries

Question

Hi

I have attached some data. In essence this is just part of a bigger workflow that i am trying to streamline. I have certain transactions where i dont have a common name to group by so was wondering if i could potentially use the tile or record tool to get the pairings or group them via formulae?

I want to check if i can do the same process with less steps pls?

Thanks!

Data Sample.xlsx

ManuelRodrigues · Answer

@pedrodrfaria

Apologies I have set out the data as it comes out from my workflow currently see attached.

Data Sample 2.xlsx

pedrodrfaria · Answer

@ManuelRodrigues Your file example mentioned to group by 4 rows. This logic will group by 4 rows at a time.

I assumed this was the logic we needed to use. Are we not supposed to be create groups of 4 and then summarize then as you had mentioned?

Regarding not working on your end, the dataset you sent is in this order:

The order right here is important. Is your data in the same order? If not, please send over the dataset in the order that your data is in so we can work with it.

ManuelRodrigues · Answer

@pedrodrfaria i tried the solution in my workflow this is what it give me: