Dear Excel-Experts,

can someone help me with my problem?
I have an Excel file of the following format:

The first column lists dates (German Format, DD.MM.YYYY), the second one lists values:

1.1.2007 5,35
2.1.2007 6,78
3.1.2007 7,56
... ..
... ..
31.2.2012 4,53


This is a list of many years, but only weekdays are listed, no saturdays or sundays.

Now I'd like to have an automatic output on a second Sheet, like this:


2007 2008 2009 .... ...
1.1. 5,35 5,0 ...
2.1. 6,78 4,3 ...
3.1. 7,56 2.5 ...
4.1. ....

If there is no value for a certain date (because it was a saturday or sunday) the cell should just remain empty.

It would be perfect if everything could be sorted with just one mouseclick (i.e. with a Macro), as I have some more datasets which change from time to time.
If I had an automated procedure I could just paste the new dataset in Column A, click on "Sort" again, and get the output for the new dataset.

Is it possible to program this?
And if yes, how?


I'd be extremely grateful for some help.
Everything I found in this and other forums could not really help me.


Thanks to everyone who is willing to help me!

Kindest regards,

Stephan


An example-Excel-file can be downloaded from my dropbox:
https://dl.dropbox.com/u/27009278/Beispiel-Datei.xlsx