I will appreciate if you could help me to Transform Multiple Row Data Into A Single Row. I thought I had an idea but it didn’t work correctly. I am trying to combine both files, removing duplicate row 1 data as file contains the same data for Row 1.
The columns which I need are:
Date de valeur
Column Libelle is where I try to transform multiple row data into one single row. Is there any chance to do it correctly?. Maybe grouping by Index? I grouped by Montant but I shouldn’t done as data might contain the same amount but it will be for different transaction description for different date. Also Is it possible to remove a space between words?
I will appreciate your help.