matrixed table out of pivot

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

including zero values in a pivot table 2
Question on the occupied field of the pivot table in excel spreadsheet 0
Average of % in pivot table 1
pivot table data 2
Pivot Table Update 3
How to create a data list from a pivot table 1
pivot table excel 2007 -- show rows with no data 1
Pivot Table date format 1

Back
Top