Hi, how do I insert an Excel column in the middle of an existing spreadsheet, and shift affected columns right?
Edit: Also, search for the header which matches a specific header name and place the new column here
Hi, how do I insert an Excel column in the middle of an existing spreadsheet, and shift affected columns right?
Edit: Also, search for the header which matches a specific header name and place the new column here
Use Insert/Delete Columns activity to insert column to the existing excel file. And specify ‘Position’ and ‘SheetName’.
Hi, I notice that Insert Column and Delete Column are classified under “Table”, does the spreadsheet need to be formatted as an Excel Table in order to use this functionality?