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.

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