have you tried using a pivot table report in the data menu.

--
Regards,
Tom Ogilvy

"awaisb" wrote in
message ...

Hello,

I have been trying to figure this out for some time now... I am soo
lost... please help


I have a data sheet which contains data for about forty products. For
each month a new row for data is added for each one of the products.

the raw data column are organized with the following headers

Date(in A1) Product name (in B1) Price(in C1)
MonthReturn(in D1)
from launch