matrixed table out of pivot
 

A bit of a challenge. I'd like to create a matrix of information using a
pivot table. So not really calculating anything, but rather have a list of
events show up as a table, with one characteristic (timing) down the rows,
and category (science, history, etc.) show up across the top. The type of
event and timing would dictate where the text would appear. Any way to
accomplish that with pivot? For that matter, anyone know of another product
that can do this?
--
Boris

Boris,

What does your original data table look like? And what do you want to transform it to?

A short example of each would help understanding your request.

HTH,
Bernie
MS Excel MVP


"BorisS" wrote in message
...
A bit of a challenge. I'd like to create a matrix of information using a
pivot table. So not really calculating anything, but rather have a list of
events show up as a table, with one characteristic (timing) down the rows,
and category (science, history, etc.) show up across the top. The type of
event and timing would dictate where the text would appear. Any way to
accomplish that with pivot? For that matter, anyone know of another product
that can do this?
--
Boris