+ Reply to Thread
Results 1 to 5 of 5

Transpose data

  1. #1
    Forum Contributor
    Join Date
    02-21-2007
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    389

    Transpose data

    Hello,

    I have a report that generate players per groups. I would need to copy and transpose the data but I do not know how to archive that!! Formulas, Macro?

    I tried with the vlookup formula but I really do not manage to have the data sorted as per the attached document (at least automatically).

    Would you think a macro could help? Please refer the attach document (the worksheet "report" is the data I need to copy and paste in the "sort" workbook. I use transpose paste to get the desired result)..

    Thansk,
    Graig
    Attached Files Attached Files

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Transpose data

    Try this:-
    Please Login or Register  to view this content.
    Regards Mick

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Transpose data

    Maybe:

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    02-21-2007
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    389

    Re: Transpose data

    @ JOHN H. DAVIS: It looks like it works okay. Can you please indicate me how to increase the range as I have like around 30 players per group? Also When I generate the report, the number of player can be below 10 or above 30 is the macro can adapt to the numbers of players per group?

    @ MickG:: The macro doesn't seem to copy the data to the report. I got the below row underligned:
    HTML Code: 

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Transpose data

    Maybe:

    Please Login or Register  to view this content.

+ 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. Transpose horizontal data to vertical data with paste link
    By M.Devadhasan in forum Excel General
    Replies: 0
    Last Post: 07-07-2012, 01:01 PM
  2. [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
  3. Macro to Transpose Data Based on Column Data
    By xxmagnusxx in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-24-2011, 05:10 PM
  4. Replies: 3
    Last Post: 02-12-2009, 02:54 PM
  5. Replies: 2
    Last Post: 02-19-2007, 04:53 PM

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