When I use the activity append range, the data i want to paste is typed in the third row (as the CELL A3 is blank) but i really want to type the information in a complete blank row (the forth row).
Select the first two rows and delete them manually. save the file and run the bot now.
You might have entered some data earlier and deleted it by selecting the cells and not entire rows. Hence the cache still exists in the file. That’s the reason data is being appended to 3rd row.
Also if you are using build datatable activity, open the column designer in the build datatable activity and check is there any empty rows there. If there, delete them by clicking ‘x’ associated with the row.