Hi all,
My case is the following:
- I have an excel file with client’s data.
- Each client has a unique code
- If the client has two products excel file will have two lines, if tree products, tree lines and so for the same client like the example below:
Key | Client | Product
001 Nm1 Prod1
001 Nm1 Prod2
002 Nm2 Prod1
I need to create an excel file with one line by client with products in different columns in the same line as below:
Key | Client | Product 1 | Product 2 | Product 3 | Product n
001 Nm1 Prod1 Prod2
002 Nm2 Prod1
any idea on how do it in Uipath?
Thanks,