Transpose large data set using MACRO

Hi,

Pls help me to transpose this file 'sample2' using macro code.
the file contains 20 variables...and supposed that there is a need to add variables from 20 to 94?
How is this possible.

Thanks