how to automatically step cells

[dajman]

hey guys,

so glad i found this forum, you guys seem to know what you are talking about...

anyhoo my problem is i have A LOT of data that is listed vertically, eg
--A---------B-------C
1 Jan 70----Type 1---100
2 Jan 70----Type 2---101
3 Jan 70----Type 3---103
4
5 Feb 70----Type 1---104
6 Feb 70----Type 2---104
7 Feb 70----Type 3---106
etc.
how do i list it like this -->

--A--------B--------C---------D
1----------Type 1---Type 2---Type 3
2 Jan 70----100------104-----103
3 Feb 70----104------104-----106
without having to Transpose copy every month group of data (because i have about 6000 lines of data).

thanks in advance for the help guys!
Daj