Results 1 to 4 of 4

Excel 2007 : How to transfer column values to rows?

Threaded View

  1. #1
    Registered User
    Join Date
    11-21-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    2

    How to transfer column values to rows?

    i have data like:
    X Y
    1 32
    1 25
    1 28
    1 34
    2 12
    2 23
    2 12
    2 35
    3 22
    3 20
    3 21
    4 11
    4 30

    Desired Output:
    1 32 25 28 34
    2 12 23 12 35
    3 22 20 21
    4 11 30

    Any Help?
    Last edited by __LENITH__; 11-21-2010 at 09:12 AM.

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