+ Reply to Thread
Results 1 to 7 of 7

Macros to transpose from multiple columns to selected columns and maintaining cell format

  1. #1
    Registered User
    Join Date
    05-31-2013
    Location
    DC
    MS-Off Ver
    Excel 2007
    Posts
    14

    Smile Macros to transpose from multiple columns to selected columns and maintaining cell format

    Can some one help in transposing data from multiple columns to selected columns while maintaining column properties with the following conditions:

    1. Employee ID - in Text format
    2. Record # - in Text Format
    3. Date Worked - in Date "mm/dd/yyyy" Format
    4. TRC - in Text Format
    5. Hours Worked - in Number (2 decimal places) Format
    6. Over Ride Rate - in Number (3 decimal places) Format
    7. Accounting Code - in Text format
    8. Pay Period Ending Date - User Defined or linked to Source worksheet cell # (Y1+14 days)

    Sample file is attached with desired data in "output" worksheet.

    Thanks

    Ravi
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Macros to transpose from multiple columns to selected columns and maintaining cell for

    Hi Rrajnish,

    Source sheet's row 1 dates are not found in your column C of output sheet for same employee... please check. Thanks.


    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    06-22-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    65

    Re: Macros to transpose from multiple columns to selected columns and maintaining cell for

    Ravi,

    I have written a macro to transform your data and attached to this post. Take a look.

    Regards

    David
    Attached Files Attached Files
    Last edited by JBeaucaire; 08-14-2013 at 10:59 AM.

  4. #4
    Registered User
    Join Date
    05-31-2013
    Location
    DC
    MS-Off Ver
    Excel 2007
    Posts
    14

    Smile Re: Macros to transpose from multiple columns to selected columns and maintaining cell for

    Thanks a tonne, David - the solution works like a charm

    Thanks to Dilipji

    Bests

    Ravi

  5. #5
    Registered User
    Join Date
    10-08-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Macros to transpose from multiple columns to selected columns and maintaining cell for

    Hi All,

    I see the solution that has been created here. I wanted something that does the reverse of this . i.e. I have data for different dates one row below the other. I would want them to be placed next to each other.

    What modifications do i need to make to this macro here to arrive at that ?

    Please guide .

    Regards,
    Subrat

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Macros to transpose from multiple columns to selected columns and maintaining cell for

    Hi subbudas,

    Welcome to the forum.
    Please create your own thread and if you wish you can give the reference of this link in your thread. Thanks.

    Regards,
    DILIPandey
    <click on below * if this helps>

  7. #7
    Registered User
    Join Date
    05-31-2013
    Location
    DC
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Macros to transpose from multiple columns to selected columns and maintaining cell for

    I am getting Run Time Error 13 and Type Mismatch when trying to run Transpose.

    Can you help please - file is attached.

    Thanks

    Ravi
    Attached Files Attached Files

+ 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