There are more ways of doing this than I care to imagine.
Some are better than others in some ways, while others may be better depending on your goal state.
I'll understand if the information is sensitive and you can't give actual details but can you suggest the structure of your data source, any naming conventions specific to this project and so on ?
Detail is key when creating scripts and without it I'd have to resort to "if column 1 is called X and column 2 is called Y and..."
Will the number of rows always be the same or will a recordset query populate the table to begin with, where the number of table rows could change ?
See what I mean about detail ?
There are loads of questions I could ask here but I will leave it to you to think about specifying what you want with as much supporting detail as possible.