List Running Horizontally-Pivot Table Possible?

J

Jugglertwo

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
 
D

Debra Dalgleish

A pivot table assumes the headings are in the first row of the source
data, so your customer would have to rearrange his data.
 
P

Peo Sjoblom

You mean like this?

Header1 x x x x
Header2 y y y y

etc.

No, a pivot table works on a typical database table with headers like

Header1 Header2
x y
x y
x y


So the solution would be to transpose the data, however you can create a
transposed link using the TRANSPOSE function that will be updated when the
original table is updated and then create the pivot from the linked table,
assume
original table is A4:Z8, in another sheet (preferably) select a range the
same size, i.e.

A2:E27

with A2 as the active cell in the formula bar type =TRANSPOSE(Sheet1!A4:Z8)

then enter it with ctrl + shift & enter

The create the pivot from the new linked table

Regards,

Peo Sjoblom
 
J

Jugglertwo

Thank you very much. It makes sense and it saves me from trying to figure out
a way that does not exist. I will try your suggestion later.
Thanks!
Jugglertwo
 
Top