T
The Mighty Ox
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.
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.