Merge rows

we could handle it within a groupby approach

  • we group the data on PRFNR and EMPNR columns
  • and process the groupmembers for the columns we want to merge side-by-side

[HowTo] Overview on different options for grouping data and processing the groups - News / Tutorials - UiPath Community Forum