Info
You are currently browsing the Chetan Shah’s Blog weblog archives for the day 3 Jun 2008.
Categories
- AML (14)
- Foundation (4)
- Personal Finance (21)
- Technology (22)
Latest Postings
- 7 Dec 2009: Move securities to Roth Account
- 28 Nov 2009: Leverage Checksum to determine identical files
- 4 Oct 2009: CAMS Certification Preparation
- 30 Aug 2009: Section 311 etc. (ACAMS Notes)
- 24 Aug 2009: FATF Membership Points (ACAMS Notes)
- 22 Aug 2009: Internet Casinos and Prepaid Cards/E-Cash (ACAMS Notes)
- 5 Aug 2009: Spousal IRA
- 15 May 2009: Buying Call Options.
- 7 Jan 2009: Watchlist filtering white paper
- 31 Oct 2008: Autonumber in Microsof Excel (works after inserting rows)
Links
Blogroll
Archives
Archive for 3 Jun 2008
Transpose Rows / Columns in Microsoft Excel
3 Jun 2008 by Chetan Shah.
There are times when we need to make the data element on an excel columns to all line up in a row.
For example : Transfer the data element in B1 to A2, C1 to A3, D1 to A4, E1 to A5 etc…
Following are the steps to transpose the elements in a particular row to a given column.
1. Select all rows (single column) where you want the elements to be transposed to. So for the above example it will A2, A3, A4, A5.
2. Enter =transpose(b1:e1)
3. Hit Shift + Ctrl + Enter
4. Done!
Posted in Technology | No Comments »
|