+ Reply to Thread
Results 1 to 5 of 5

Transpose multiple rows to columns sheet attached

  1. 07-11-2012, 08:25 AM #1
    ahad_bwp
    ahad_bwp is offline
    Registered User
    Join Date
    07-11-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    6

    Transpose multiple rows to columns sheet attached

    hi everyone!
    I tried searching the forum for the answer but I just could not find it...
    I would be really grateful if someone could help me out!

    I frequently have to work with tables set up like this:

    Sr No. Account NAME ADDRESS

    1 3657860000 MUHAMMAD 42-C NIL BLOCK Y MODEL TOWN
    NADEEM CHUGHTAI Bahawalpur

    2 4657860000 MUHAMMAD IRFAN NIL NIL BLOCK Y MODEL TOWN
    city town bahawalpur
    3 3347760000 MUHAMMAD ALI NIL NIL SADIQ PB RESIDENTIAL
    Chugtai S/o Ahmed CLY AHMED PUR EAST ROAD
    Bahawalpur
    4 8943860000 BEGUM TARIQ 89-B NIL GHALLA MANDI MODEL
    FAZAL QURESHI TOWN B
    Bahawalpur
    5 9943860000 MUHAMMAD IKRAM BV-2068 NIL GHALLA MANDI
    MODEL TOWN B
    Bahawalpur
    i want to convert name and address rows to columns
    sheet attached.......
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-11-2012, 08:29 AM #2
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Transpose multiple rows to columns sheet attached

    How does your original data look? It will be good if you post a Before & After sheet so we can help you better.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
  3. 07-11-2012, 08:35 AM #3
    dilipandey
    dilipandey is offline
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Transpose multiple rows to columns sheet attached

    Hi Ahad,

    I believe you have the solution in your sheet 4
    If not, share the updated workbook as Arlette suggested. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]
    Reply With QuoteRegister To Reply
  4. 07-11-2012, 08:41 AM #4
    ahad_bwp
    ahad_bwp is offline
    Registered User
    Join Date
    07-11-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Transpose multiple rows to columns sheet attached

    Quote Originally Posted by arlu1201 View Post
    How does your original data look? It will be good if you post a Before & After sheet so we can help you better.

    Sheet is attached.........


    and i ma new in this
    Reply With QuoteRegister To Reply
  5. 07-11-2012, 08:51 AM #5
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Transpose multiple rows to columns sheet attached

    I guess you forgot to attach the sheet.
    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