Invert Excel Data Table

Hello Excel Forum,

The data I get from a Website is an Upside Down Table = Last Date on first Line
The length of the list of dates can vary
As I need the Date in the MM/DD/YY Format
In Green Fill Colored Cells B29 to B54 I have converted the incoming Date Data into MM/DD/YY
It is an Unusual formula but it works

Could you please tell me how to Invert the Data Table Cells C1 to G26 Yellow Fill Color

and place the Inverted data into cells C29:G64 the Grey Filled Area to the right of the corresponding dates

As an example I have typed in the Values in cells C29..G31

See attached Excel Spreadsheet : _FT__DATA_Excel _Forum


Thanking you in advance

Best regards,

Derek

Duplicate reply

Derek

Hi worswick,

Your data has year values in the dates and range from 1980 up to 2029. If you sort these, the year number is used in the sort.

Sorting data is really easy once you see how to do it. Understanding why you get your answer (because you have lots of different years) is a little harder.

See: http://www.contextures.com/xlSort01.html for some good instruction and examples.

Duplicate posting