user09423 Member

I want to mention -- I think the most pertinent question for my application is simply whether or not Magic ETL or the like can take a row's date string from a cell on one worksheet, and copy that row's various column data, transplanting it at various places on the second worksheet within the row it finds that string/date…

Thanks for the tips. The purpose of the format is given the size of the Location set. We actually have about 14 active location codes. In their raw submission form, each inspection carried out in one of the cities is submitted from a tablet and added to the rows (Sheet1). This gets a bit laborious when you're counting rows…