I have 2 sheets with the same structure that I want to merge them creating another sheet. Is this possible?
The actual case is that the only difference between those two, is the Id field: at the first sheet is auto generated, while at the second is keyed-in. So after the records have being created in either ways, I need to merge them for further proccessing.
Is there a way to do that, or can you think of any workaround?
Use this if only a few fields are different as you can filter.
Otherwise if you do not need this to be real time then as a once off you can export both to CSV and merge them in Google sheets or Excel and then import them into the new sheet.