Re-arrange the columns position in Excel

Hi Everyone,

I would like to ask how can I re-arrange the columns position in excel from this:

To this:

I am able to use the Data Set-Ordinal method but I would not want to use it as it requires additional third party packages. Is there any way to change the position of the columns using a for loop etc ?

Hi @Hey_hi ,

  • Read the excel
  • Use Filter Datatable Activity in output column tab add all the columns in the order you want
  • Get the output and Write the datatable back to the same excel

look at the answer here @Hey_hi

Alright!! thank you!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.