Hi everyone, Please help with the attached problem.

Hi everyone,

Please help with the attached problem. I have made 2 sheets in the attached file, one for the input and second sheet is the desired output sheet.

Thank you in advance!!

Accepted answers

This is a bit of regex to replace the carriage return and then splitting to rows on the Supplier ID:

Workflow attached.

Hi M,

Thanks a ton for the quick help.

The supplier id is sorted but the amt is not showing as per the desired output, can you please help? Thank you so much again in advance!