Over the past year we've created 440 reviews - each review is documented in a seperate excel file. Each review covers 20 to 25 different tests, Column A is in all cases the test name (sorted test#1, test#2, test#3, etc). Ultimately I want to get all the rows together (about 11,000 rows) so I can resort by test number (ie 440 test#1's grouped together, 440 test#2's grouped together and so forth). Does this need to involve 440 manual copy & pastes, or is there an easier way?
Thanks in advance for any help you can provide
Thanks in advance for any help you can provide