So I have a number of sheets that are being merged into a single master sheet using SheetGo.
I am then using a Arrayformula to move the merged data across to an editable sheet. I have one column on that sheet that I need to manually add data to.
The problem is that every time I update one of the individual sheets, the order of the rows changes on my editable sheet, making it impossible to add data to that column for a specific row.
How can I get my rows to stay in the same order?