+ Reply to Thread
Results 1 to 3 of 3

transpose multiple rows into two columns

  1. #1
    Registered User
    Join Date
    09-13-2010
    Location
    jkt, indonesia
    MS-Off Ver
    Excel 2007
    Posts
    3

    transpose multiple rows into two columns

    Hi there, basically what I need is the reverse of this thread:
    http://www.excelforum.com/excel-gene...lete-rows.html

    that is my data is:
    A 0.66 0.77 0.88
    B 0.44 0.33
    C 0.55 0.66 0.88 0.99 0.44

    i need it to be:
    A 0.66
    A 0.77
    A 0.88
    B 0.44
    B 0.33
    C 0.55
    C 0.66
    C 0.88
    C 0.99
    C 0.44

    please help, thank you !!

  2. #2
    Forum Contributor
    Join Date
    12-26-2008
    Location
    India
    MS-Off Ver
    2007
    Posts
    122

    Re: transpose multiple rows into two columns

    Right Click-Paste Special-Transpose

  3. #3
    Registered User
    Join Date
    09-13-2010
    Location
    jkt, indonesia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: transpose multiple rows into two columns

    i know that command
    and thats not it

    im asking a different question

+ Reply to Thread

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