Transposing Data allows you to re-arrange rows into columns or vice versa – basically interchanging the two.

1. Select then copy desired cells
2. Click on cell where the transposed data should display
3. On the Home tab, in the Clipboard group, click the drop-down arrow under the Paste button and choose Transpose
   

Tags: Columns, Excel 2007, Microsoft Excel, Rows

This entry was posted on Monday, April 13th, 2009 at 5:05 pm and is filed under Microsoft Excel. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.