I have 5 files of excel files. I want to merge in one file. I tried to get range and set range but it doesn’t work. How to append to the end of the column?
You can vote to add it as a feature in this topic
You can use this solution int he meantime:
after you’ve saved data from excel files to tables, calculate the number of rows in the tables (except the last one)
define the cell from which to start inserting data through a Number variable
calculate the cell from which each new range starts by adding the number of rows to the starting cell
use the result in the Set Range action
Here is a sample recording
append-table.zip (24.5 KB)
perfect. I did the right one. This is exactly what I did.
Thank you so much.