Hi, I have data in two rows and I want it to be pulled into a single row. Everytime the automation run, it must scan two rows at a time and then add it to a single row. And this process triggers everytime data is filled in two rows. Better example I have data in A1,B1 and A2, B2 of a sheet1, i want it in A1,B1,C1,D1 of sheet 2. Next when someone fills data in A3,B3 and A4,B4, the scenario must trigger.
Please suggest
how are you going to populate sheet1 manually or by using a make scenario or by other services ?
Hi, Yes it will be mostly manually
you can use watch new rows
here is an example of how you can do it considering you are entering the data in the sheets1 manually
here are sheet 1
and sheet 2
add a watch new rows module
then add an array aggregator and select the columns you want
then add a repeater with these settings
then add a sheets add a row module like this and select the columns you want in 4 different columns and use the repeater variable inside the of array for 1st and 2nd column and in the 3rd and 4th column add [i+1]
then schedule it to desired time or days
if you run it by adding values both sheets would look something like this
if there are odd number of rows added then the in the sheet2 would have gaps in column 3 and 4 and the new entry would start from new row like this
Thank you so much @abhilash_naik , i will try today.