List Running Horizontally-Pivot Table Possible?
I just had a customer ask this one and I'm not so sure
about it.
1) The customer has setup a list of information that is
running horizontally instead of the typical list running
vertically.
2) I just taught him how to do pivot tables and he wants
to generate a pivot table with his "horizontal" list.
3) I know he can copy and paste special and use the
Transpose feature to change the list from horizontally
oriented to vertically oriented.
4) the question is: can he leave the table in its original
orientation and still generate Pivot tables? I can't seem
to make it work and would like to know if it is possible
or not.
Thanks for an assistance on this request.
Jugglertwo
|