I need vb macro coding for transpose of the columns into rows. For the completion of every Season, the AVG column has to be converted into row... please give me the complete coding.. I m also attaching the excel file for your easy understanding in which I worked out the output manually.
pls do help me.. I need it very urgently...
MY EXCEL FILE IS LIKE:
SEASON AVG
1969 1
1969 1
1969 1
1969 1
1969 1
1969 1
1969 1
1969 1
1969 0.97975
1969 0.872875
1969 0.831545455
1969 0.925555556
1969 1
1969 1
1970 1
1970 1
1970 1
1970 1
1970 1
1970 1
1970 1
1970 1
1970 1
1970 1
1970 1
1970 1
1970 1
1971 1
1971 1
1971 1
1971 1
1971 1
1971 1
1971 1
1971 0.857
1971 0.515
1971 0.5192
1971 0.684555556
1971 0.972777778
1971 0.8864
1972 1
1972 1
1972 1
1972 1
1972 1
1972 0.9921
1972 0.844166667
1972 0.394142857
1972 0.35875
1972 0.987428571
1972 1
1972 1
1972 1
OUTPUT:
I need output to be in the form as follows:
1969 1 1 1 1 1 1 1 1 0.97975 0.872875 0.831545 0.925555556 1 1
1970 1 1 1 1 1 1 1 1 1 1 1 1 1 -
1971 1 1 1 1 1 1 1 0.857 0.515 0.5192 0.684556 0.972777778 0.8864 -
1972 1 1 1 1 1 0.9921 0.844167 0.394143 0.35875 0.987429 1 1 1 -
Bookmarks