Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert a square of data into a PivotTable?
Not sure if anyone can help me out with this but I'm looking for a fairly
easy way to convert a square (or rectangle most likely) into a PivotTable. What I've got is 12 columns of data that could have any number of rows in them... and presently I have to copy the first column into a new sheet and then copy each subsequent column into the new sheet onto the bottom of the data that's already been copied across. Once I've done this I can PivotTable this as normal. But what I'm wondering is if there is a quicker way of doing this? If I could PivotTable across the columns I would but I don't think I can and so this seems to be the easiest solution. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert a square of data into a PivotTable?
To reorganize the data, you can use the "unpivot' technique described by
John Walkenbach: http://j-walk.com/ss/excel/usertips/tip068.htm The Mighty Ox wrote: Not sure if anyone can help me out with this but I'm looking for a fairly easy way to convert a square (or rectangle most likely) into a PivotTable. What I've got is 12 columns of data that could have any number of rows in them... and presently I have to copy the first column into a new sheet and then copy each subsequent column into the new sheet onto the bottom of the data that's already been copied across. Once I've done this I can PivotTable this as normal. But what I'm wondering is if there is a quicker way of doing this? If I could PivotTable across the columns I would but I don't think I can and so this seems to be the easiest solution. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivottable - use same source data, and group data differently | Excel Discussion (Misc queries) | |||
Data values WON'T DELETE in PivotTable drop-downs | Excel Discussion (Misc queries) | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
How do I convert monthly data to quarterly data? | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions |