Convert Data to columns heading

[cheerboy555]

Example:
Product | Date | Sales
-----------------------
A | Jan94 | 200
A | Feb94 | 300
A | Mar94 | 400
A | Apr94 | 500
A | May94 | 600
A | Jun94 | 700
A | Jul94 | 800
A | Aug94 | 200
A | Sep94 | 300
A | Oct94 | 400
A | Nov94 | 500
A | Dec94 | 600
B | Jan94 | 200
B | Feb94 | 300
B | Mar94 | 400
B | Apr94 | 500
B | May94 | 600
B | Jun94 | 700
B | Jul94 | 800
B | Aug94 | 200
B | Sep94 | 300
B | Oct94 | 400
B | Nov94 | 500
B | Dec94 | 600

How can I convert it to:
Product | Jan94 | Feb94 | Mar94 | Apr94 | May94| Jun94 | Jul94......
---------------------------------------------------------------------
A | 200 | 300 | 400| 500 | 600 | 700 | 800 .....
B | 200 | 300 | 400| 500 | 600 | 700 | 800 .....

Does Excel contains certain function instead of retype all data?

Thanks a lot.

 

[Gazzr]

Hi,

Doing a Pivit Table would be one way.

Higlight the range of cells including Column headings etc

Click Data > Pivot Table > Next > Next > Layout.

Drag the Product button to the Row section of the Pivot table, Dat
button to Column section and Sales to the data section (make sure i
says "Sum of Sales"). If not double click the buton and change
Click OK > Finish and you should get the results you nee

 

[cheerboy555]

Thanks very much. problem solved