kimbenz
06-16-2020, 09:18 PM
Good Day Mates,
I'd like to seek your help for my problem, as attached in file.
I have Raw Data in row 2 - 6 and my expectation is to breakdown each raw data by REMARKS INVOICE PAYMENT as can be seen in row 9 - 17.
If Remarks Invoice Payment contain more than one invoice than it need to be insert as new row, and also including the amount of invoice which contain in between the brackets "( )".
Highly appreciated for the feedback. Thank you!
Cheers!
I'd like to seek your help for my problem, as attached in file.
I have Raw Data in row 2 - 6 and my expectation is to breakdown each raw data by REMARKS INVOICE PAYMENT as can be seen in row 9 - 17.
If Remarks Invoice Payment contain more than one invoice than it need to be insert as new row, and also including the amount of invoice which contain in between the brackets "( )".
Highly appreciated for the feedback. Thank you!
Cheers!