Results 1 to 5 of 5

Shortcut in Transposing Rows to Column

Threaded View

stormracela Shortcut in Transposing Rows... 03-05-2013, 08:53 AM
outofthehat Re: Shortcut in Transposing... 03-05-2013, 01:04 PM
stormracela Re: Shortcut in Transposing... 03-05-2013, 10:39 PM
MyOpSys Re: Shortcut in Transposing... 03-07-2013, 02:46 PM
bhavin_1981 Re: Shortcut in Transposing... 03-22-2013, 11:51 AM
  1. #1
    Registered User
    Join Date
    03-22-2010
    Location
    Manila
    MS-Off Ver
    Excel 2007
    Posts
    46

    Shortcut in Transposing Rows to Column

    Good Morning, I just want to know if there is a short cut for the 'Transpose" function doing rows to column. I have 6000 rows that I need to transpose but I want to transpose 10 rows to 10 columns in row #1, then another 10 rows to 10 columns in row #2 etc.

    ex.
    rows 1-10 transpose to A1, A2, A3, A4, A5, A6, A7, A8, A9, A10
    rows 11-20 transpose to B1, B2, B3, B4, B5, B6, B7, B8, B9, B10
    rows 21-30 transpose to C1, C2, C3, C4, C5, C6, C7, C8, C9, C10

    I attached a sample file for example.

    Thanks in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1