How To Maintain Row Order After Importing Dynamically From Multiple Sheets


#1

Hey guys,

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?


#2

Hi @thebrandarmy,

How about an approach as presented in this example spreadsheet? :slightly_smiling_face::wave: