Take two rows data at one time from a gsheet and add to single row in another gsheet

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
image

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.