+ Reply to Thread
Results 1 to 3 of 3

Transpose dissimalar rows in to columns in excel

  1. 12-02-2012, 11:23 AM #1
    wallnut
    wallnut is offline
    Registered User
    Join Date
    12-02-2012
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    1

    Thumbs up Transpose dissimalar rows in to columns in excel

    example
    a b c are columns in excel
    a b c
    name Sl No code
    abcd 010 102035
    abcd 020 652341
    abcd 030 012454
    zsew 010 123456
    zsew 020 895623
    zsew 030 552963
    zsew 040 258147
    zsew 050 987654
    required format
    abcd 102035 652341 012454
    zsew 123456 895623 552963 258147 987654
    Reply With QuoteRegister To Reply
  2. 12-02-2012, 12:27 PM #2
    mike7952
    mike7952 is offline
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,520

    Re: Transpose dissimalar rows in to columns in excel

    Give this a try

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    Reply With QuoteRegister To Reply
  3. 12-02-2012, 12:32 PM #3
    Jakobshavn
    Jakobshavn is offline
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Transpose dissimalar rows in to columns in excel

    This will fill data from Sheet1 into Sheet2:

    Please Login or Register  to view this content.
    Gary's Student
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1