How to append data one row which is behind on target sheet

[Tharusha_Fernando (Fernando ✔️)]

i m appending two data tables but the data data table which i append is a coloum behind the target data row how to fix an append it …make it for two column name ,country

[tavineei (Tav)]

Hi,
How do you append data to existing excel file ?
I recommend to use ‘Append Range’ with new data (as data table) to append data to existing excel file.

Append Range

[Tharusha_Fernando (Fernando ✔️)]

i used append data activity, the excel file which i append have a blank column and the target excel file doesn’t have a a blank column in ist is their a way to send all the appending colomns in to a side by one row or any

[dimibot (Dimitrios)]

You can remove the empty column using Remove data column activity. https://docs.uipath.com/activities/docs/remove-data-column