Arrange time series data into year/month/day

Hello,

I have a matrix in the form of time series data arranged as:

Year Month Day 1991 Jan feb march april...dec 1...31 1992 . . . . . . 2000

I would like to transpose the data so that it looks like:

1991 Day jan 1-31 . . . . . . Dec 1-31

2000 etc

I appreciate your response.

Elvis.

[Azzi Abdelmalek]

in 1991 Day jan 1-31 what is 1-31?

[ASONG ZILEFAC]

Hello Azzi,

Assume that Jan is from 1 to 31, Feb from 1 to 28 or 29 ....Dec 1 to 31 days. The data is currently in the format: 1991 1 to 31 for Jan, 1 to 28 for Feb etc. 1992 1 to 31 for Jan, 1 to 28 for Feb etc. Some years might be leap years as well.

I want to transpose the data so that months are aligned under each year ,and days in front of each month:

1991 Jan 1 to 31 Feb 1 to 28/29 . . . Dec 1992 Jan ... Feb ... . . . Dec ...

ETC.