Sort excel list base on category keywords

Help
1

Hi, I have this excel file which I will like to rearrange the line items base on category. Meaning all the key chains together, a spacing, then all the Tees etc. Not just the description but also the code and quantity. I also need the total line to be still present. How can I do that?
image

Thanks in advance!

2

@SJL

Step1: Read the Excel
Step 2 : remove Empty rows by using below code in Assign Activity
DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(“”))).CopyToDataTable()
step 3: Sort the excel (Using Sort DataTable)

Hope this will help you
Thanks,
Suresh J

3

Hi @SJL

For sorting you can use based on assign activity

DataView view = new DataView(table)
DataTable distinctValues = view.ToTable(true, "Column1", "Column2" ...)
Thanks
Ashwin.S