We help IT Professionals succeed at work.

Pivot Table - transpose?

pdvsa
pdvsa asked
on
Experts,

I have to put this excel file in a pivot table
But it seems like in its present form it cant be done.
The field names appear to be along the left side running down .
I am looking for ideas of how to get the data in the proper format.

Any tips?  

thank you (hope the pic is large enough)
untitled.JPG
Comment
Watch Question

CERTIFIED EXPERT
Commented:
It looks like that is already a table.  Pivot table works best with rows of data.  

What are you hoping to accomplish?
Commented:
you can transpose the data by ensuring the column labels are in one cell i.e. "Previous Balance" should be in one cell rather than two cells... then copy the data i.e. select everything from cell A2:L50 then copy and paste special but select transpose and values this should work,....

Explore More ContentExplore courses, solutions, and other research materials related to this topic.