Tuesday, November 27, 2012

How to Flip Column Headings As Row Headings on an Excel Spreadsheet


1. Select and copy the entire data range you want to transpose. For example, if you have 10 columns and 10 headers, highlight them as well as all the data within. Excel will accurately transpose not only the column and header titles but also the data.
2. Click on a new location in your worksheet for the transposed information to go. The simplest thing to do is go down a few columns and click. This way you can compare the new information with the old before deciding which information to keep. You can delete the other data or decide to use the information in both formats.
3. Click on the “Edit” menu, then select “Paste Special” and click on the “Transpose” check box (located on bottom right of window). This will copy the information and transpose it at the same time, as opposed to the 'Edit' > 'Copy' function, which will merely copy the information but not transpose it.
4. Click the “OK” button and Excel automatically transposes the column and row labels, as well as all the data. This is important to understand because it will save you a lot of time when you realize you need to transpose headers and columns. It doesn't just transpose the header and column names, it also reorganizes all the data where it belongs.
5. Compare the new data with the old data and decide whether you want to keep both or just one set of data. It may be helpful to provide both sets of data as a draft to get an objective perspective on which works better. Then, once you've sought an outside opinion, you can delete one set of data. Either way, it's handy to have both available in case you decide the data was better in the original format before you transposed it.

Blogger news