Select the range in question, go to Data--Pivot table and follow the
wizard's instructions.

Dave
--
Brevity is the soul of wit.


"Meng" wrote:

I receive real time data from a quote service for index futures. The data is
constantly changing. How do I store that data into a pivot table?