I’m trying to prevent the first 7 rows from being duplicated when my automation filters through the master data file and copies/pastes the data into the new sheet.
Hi @J_Jalapeno ,
Maybe another way to go about it is Filtering based on the First Name column (Column Index 2) in the Filter Datatable activity by using the Condition as Not Empty ?
Could this be a possible case that you could try and is accepted ?
@supermanPunch I don’t think that’ll work, as I have to filter by ‘Company Name’ as there are multiple groups and a different sheet for each group.