excel change of input to output format

Help Activities
,
1

excel change of input to output format

Use Case Description

we have two table in the screen short so we have to change input data to desire output format

AS-IS WORKFLOW, TO-BE WORKFLOW

image.png
image.png385×515 13.5 KB

Other information about the use case

Industry categories for this use case: Logistic

Skill level required: Beginners

UiPath Products that were used: UiPath Studio

Other applications that were used: excel

Other resources: -

What is the top ROI driver for this use case?: Accelerate growth and operational efficiency

2

@Shishir_Kumar

Follow the steps

  1. Use build datatable and build a table with 3 columns and of type string and let it be newdt and say original data is in dt
  2. Use for each row in datatable on dt
  3. Use for each activity with in argument as Enumerable.Range(1,dt.Columns.Count-1).ToArray and change type argument to integer
  4. Now inside the second loop use add data row with datatable as newdt and array row as {currentrow(0).ToString,dt.Columns(currentitem).ColumnName,currentrow(Currentitem).ToString}

Hope this helps

Cheers

3

Can you send me the pic.