Consolidate Rows in Data Table

[vvaidya (Vinay Vaidya)]

This should give an idea

5. RPA Challenge - Reorganizing Excel Data Sheet

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] Image 2 [image] Image 3 [image]