How to create list in excel

I want to extract (filter) the column Emp No
for the employee numbers in the form of a list

The output I want is 1,22,109.

Hi @Muneer_Alrashdan
Welcome to UiPath community
dt1.AsEnumerable.Select(Function(r) r(“columnname”).ToString.Trim ).Distinct.ToArray

Hi @Muneer_Alrashdan ,

You can try this one also

dtTable.DefaultView.ToTable(True, "ColumnName")


Follow these steps to create a custom list by entering values:

For Excel 2010 and later, click File > Options > Advanced > General > Edit Custom Lists.

For Excel 2007, click the Microsoft Office Button Office button image > Excel Options > Popular >Top options for working with Excel > Edit Custom Lists.

In the Custom Lists box, click NEW LIST, and then type the entries in the List entries box, beginning with the first entry.

Press the Enter key after each entry.

When the list is complete, click Add.

The items in the list that you have chosen will appear in the Custom lists panel.

Click OK twice.

Hope This Works,