Hello,

I will be receiving 100 or more xls per month which have rows as fields and
columns as cases/individuals/records, the opposite of standard db structure.

How would I go about writting a script that would open each of these and
transpose it without me doing them one by one? Their names will vary from
month to month.

Thanks in advance,

John