Closed Thread
Results 1 to 3 of 3

Transpose Multiple (& Varying) Rows into Multiple (& Varying) Columns

  1. 01-05-2017, 01:33 AM #1
    Andrea9578
    Andrea9578 is offline
    Registered User
    Join Date
    01-05-2017
    Location
    Memphis
    MS-Off Ver
    2016
    Posts
    3

    Exclamation Transpose Multiple (& Varying) Rows into Multiple (& Varying) Columns

    I have a problem that seems like it should be easy to solve, but I don't have enough experience in Excel to solve it.

    I have thousands of data lines in the following format:

    Attachment 495768


    This is just an example of what the data looks like. The number of Employees assigned to each Manager could vary from 1 to 15 or more.

    and I need to change the format to:

    Attachment 495769



    Any help is appreciated!!
    Reply With QuoteRegister To Reply
  2. 01-05-2017, 02:04 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: Transpose Multiple (& Varying) Rows into Multiple (& Varying) Columns

    Duplicate thread closed. Please continue here: http://www.excelforum.com/showthread.php?t=1168600
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 01-05-2017, 02:05 AM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Transpose Multiple (& Varying) Rows into Multiple (& Varying) Columns

    Probably forum-induced. It's been messing around all day
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to combine multiple sheets with varying columns
    By Louis85 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-24-2015, 05:47 AM
  2. Need to transpose one column into multiple with varying data
    By Topher77 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-21-2014, 06:06 PM
  3. Copy multiple columns with varying number of rows into one column on a new sheet and loop
    By cammyjane10 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-27-2013, 03:58 PM
  4. Multiple columns (more than 10) in a listbox with varying formats
    By iain79 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-04-2012, 10:55 AM
  5. Need to sum rows from multiple tables with varying layouts
    By Giger in forum Excel General
    Replies: 4
    Last Post: 07-09-2012, 01:44 PM
  6. Transpose rows to columns with varying numbers of lines per record
    By SerPetr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2006, 11:40 PM
  7. Transpose rows to columns w/varying numbers of lines per record
    By MG in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-10-2005, 09:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1