How to sort the column in excel which doesnt have any column name


#1

I have one excel, it has data from mid of the excel,the column doesn’t have any header, and any column name.
i want to sort the whole excel sheet data using that column.can anyone please me with that.

Thanks
Ananthaeswar.


#2

Hello @Ananthaeswar2,

Hope this could help:

If you are using Excel Read Range Activity to get the excel table (with option AddHeaders unchecked) then columns are by default named Column0, Column1 … and so on.
Here is an example:
sortTable.zip (7.5 KB)

Take a look at this:

Regards,
Susana