Therefore, it will be great if you can post a loop that can be used with union all to transpose datasets such as the one you wrote the previous loop for, please.
I would like to thank you for your help in advance. I have a table called sheet1. It has a field for ID (PID), and many fields for scores assigned by evaluators (text not number) The fields have the same first part (Rev) and a numbers appended to them : Rev1, Rev2, etc. I want to loop through...