5. RPA Challenge - Reorganizing Excel Data Sheet

datatable
excel

#1

I have an Excel spreadsheet(For Example Sheet1) as in image 1.I want to organize it in an new sheet(Sheet2) as in image 3. Iwant to create a list to store material codes as in image 2 and I can add more material codes later. After I create the new sheet2, I need to delete sheet1 from the excel file.

Image 1
Image 2
Image 3


Automation Challenge Winners
Consolidate Rows in Data Table
#2

Excellent question. Moved to automation challenge.


#3

I’ve found a way to add the material names along their codes in a data table by using Build dataTable Activity.


#4

Good. Why not attach the workflows?


#5

Hi there is my workflow for this challenge :slight_smile:

RPA Challenge - Reorganizing Excel Data Sheet.zip (10.9 KB)


#6

Hi @Masire,

Really great code to have in forum :slight_smile:

Regards,
Rahul


#7

Travail incroyable, j’essayais de comprendre la première partie MDR


#8

Thanks @beesheep & @Rahul I tried to do my best :grin:


#9

HI I have tried this challenge with Sql Query…In order to run this file all u need to do is change the path of Excel file in connect Activity…
First.zip (500.2 KB)


#11

I have completed the challenge please check and let me know… Recognizing Excel Data Sheet.zip (17.0 KB)