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 ...

Get Managing Data with Microsoft® Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.