+ Reply to Thread
Results 1 to 10 of 10

Transpose

  1. #1
    Registered User
    Join Date
    05-27-2011
    Location
    Virginia
    MS-Off Ver
    Excel 365
    Posts
    86

    Transpose

    Hi,

    I've been trying for quite some time to get a macro which would transpose the starting data worksheet to the desired results worksheets. The starting data worksheet number of rows will be dynamic. Please see the attached Test Data workbook.

    Thanks in advance for any assistance.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    206

    Re: Transpose

    How about using a pivot table (see attached)?
    Attached Files Attached Files

  3. #3
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Transpose

    Hi MusicMan

    Please show your anticipated results for HOLMES JAMES for the months of Jan, Feb and Mar.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  4. #4
    Registered User
    Join Date
    05-27-2011
    Location
    Virginia
    MS-Off Ver
    Excel 365
    Posts
    86

    Re: Transpose

    Thank you for you quick response Raphaelp and jaslake. I really wanted a macro because it would be part of a total group of macros which would aid in completing the report. Sorry that I used multiple months for several Managers in the Test Data workbook but only one month would apply for each Manager. I've corrected the workbook and completed the anticipated results for HOLMES JAMES. Please see the revised workbook. Thanks again for your assistance.
    Attached Files Attached Files

  5. #5
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Transpose

    Hi MusicMan

    Makes a bit more sense...I'll look at it tomorrow.

  6. #6
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Transpose

    I agree with Raphaelp,

    A simple Pivot Table answers the question without needing any formulas or VBA.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  7. #7
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Transpose

    VBA
    Please Login or Register  to view this content.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    05-27-2011
    Location
    Virginia
    MS-Off Ver
    Excel 365
    Posts
    86

    Re: Transpose

    Fantastic, thank you so much jindon. It works like a charm.

  9. #9
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Transpose

    I think I made it too complicated.
    Simply...
    Please Login or Register  to view this content.

  10. #10
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Transpose

    well another way. I agree with Marvin Pivot table would work great. Nice and short code Jindon.

    Please Login or Register  to view this content.
    Last edited by mike7952; 03-01-2017 at 10:51 PM.
    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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Use the TRANSPOSE() function to transpose a range as an input to the UDF
    By alice2011 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-09-2015, 09:35 PM
  2. transpose column to a range calculate and transpose to new table loop
    By moshro1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-02-2015, 10:52 AM
  3. [SOLVED] Excel 2007 : Cut\transpose vs. copy\transpose
    By sarahaley in forum Excel General
    Replies: 3
    Last Post: 05-09-2012, 05:45 PM
  4. [SOLVED] Transpose: How can I copy a list and transpose it but leaving 3 cells in between each item
    By cocolete in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-11-2012, 10:01 AM
  5. Replies: 2
    Last Post: 02-19-2007, 04:53 PM
  6. Replies: 1
    Last Post: 12-29-2005, 07:50 PM
  7. [SOLVED] I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES
    By Umair Aslam in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-22-2005, 09:05 AM

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