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

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

Jugglertwo wrote:
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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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



"Jugglertwo" wrote:

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

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

"Peo Sjoblom" wrote:

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



"Jugglertwo" wrote:

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