• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. Excel's Data Management Features > Rearranging Data with TRANSPOSE

Rearranging Data with TRANSPOSE

On the Web and on Usenet, there are various forums and newsgroups devoted to the asking and answering of questions about the use of Excel. And there are plenty of FAQ lists that summarize the answers to the most popular of those questions. One common question goes something like this: “I have a range of data that I imported from a database into Excel. I want to print it, but even in Landscape mode the range is too wide for the paper. I'd be okay if I could print the rows as columns and the columns as rows--that is, if I could reverse the orientation. Is there a way to do that?”

That question has lots of variations. Sometimes it's convenient to key in the data with one orientation, but it turns out that it's the wrong setup for charting the data, or analyzing the data with a pivot table, or some other activity that won't cooperate with the data's layout. There are a couple of good ways of dealing with this situation, both involving the term transpose (see Figure 2.13).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint