I have a spreadsheet (we’ll call it SS1) of 100+ rows with all different types of characters, numbers, dates, everything.
What I want to do is copy/cut a row of data, put it on another, blank, spreadsheet (we’ll call this one SS2) and save it. This will then be uploaded elsewhere.
Then I’d like it to loop through SS1, copying each row individually and saving it on SS2. Only one line at a time can appear on SS2 due to the data on it so the data from SS1 will either have to copy over the line, or the line on SS2 will have to be deleted first.
Is there a way this can be done? I thought it’d be a “for each” activity job but I’m struggling to work out how the data will be copied.
Thanks in advance