How to group/match different fields in different columns

[Sousou]

Hey everyone,

I'm face of a difficult situation (i think) :p

This is exactly the kind of data i have to process with alteryx :

datatest

And i want to transform data in this format:

data result

The problem is to match the number account and the name of the account  WITH  the date, the debit and credit which are on other lines, I don't know how to proceed to succeed this transformation..

Can someone help me?

Thanks a lot in advance !!

[jasperlch · Accepted solution]

Hi, a combination of Multi Row Formula, Filters and Text to Column tools will do the job:

[Sousou]

Hi Jasperich

Thank's a lot for your help ! it works very well :)