How to sort the row based on "Type"

[Happydayyy (22035153d)]

May I ask how I can re-arrange the row based on ‘Type’?

Now the output is:

But I want my output that is sort by “type”

[postwick (Paul Ostwick)]

Read Range into a datatable
Sort Data Table activity
Write Range back to spreadsheet

[Happydayyy (22035153d)]

Can you give me an illustration. Thank you!

What i need to input here?

[pikorpa (Piotr Kołakowski)]

Hey @Happydayyy
you can use this solution. Please take a look:

dtSorted = dtExcelData.AsEnumerable().OrderBy(Function(row) row("Type")).CopyToDataTable()

BlankProcess105.zip (11.4 KB)

[parvathi_ayanala (P@89)]

Hi,
If you want type to be sorted into your data table?
dt.AsEnumerable.Where(Function(row) row(“Test meth Type”).toString).CopyToDataTable()

[Anil_G (Anil Gorthi)]

@Happydayyy

You can directly use sort excel activity

Activities - Sort Range

Cheers

[postwick (Paul Ostwick)]

It says “Data Table” so that is where you put your datatable. Also, you have to fill in the rest of the properties in the Properties panel.

[Happydayyy (22035153d)]

I marked the solution. Thank you so much for helping me cope with this issue.