Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
matrixed table out of pivot | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |