Excel Tip of the Day

Easily transpose a range of data (Excel 97/2000/2001/2002)

Occasionally, you may have data stored in a worksheet column that you'd prefer to have organized in a row--or vice versa. Fortunately, it's easy to transpose data, even if you want to transpose multiple rows or columns. To do so, select the range that you want to transpose. Select Edit | Copy from the menu bar. Then, select the new destination for your data and choose Edit | Paste Special from the menu bar. When the Paste Special dialog box appears, simply select the Transpose check box and click OK. If the range you're transposing contains multiple columns and rows, the data from the source range's top row is placed in the left column of the new range, and the original range's left column becomes the new range's top row.

(Content provided by Element K Journals)

(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
PrintPrint CloseClose

Copyright © 2001 - 2017 MJ Technologies, LLC.  All rights reserved.