A csv existing of 6 columns (Delimiter: Semicolon) has to be re-arranged by consolidating rows with the same ID.
So I first need to identify all different IDs so that afterwards rows with the same ID can be Consolidated within a single row. Three of the related values (in the other columns) are equal for each group (of identical IDs). So either the first or last record can be taken.
But for two of them (marked blue) I need to total up the values in the cell (related to the same ID) - see screenshot below:
Please find a sample file attached…
UiPath Forum.zip (442 Bytes)
To sum it up…
Columns D and E need to be consolidated based on the (same) ID in column A.
For the other columns either the first or the last record can be taken.
Thanks in advance for your help!