+ Reply to Thread
Results 1 to 4 of 4

Transpose a list of related values

  1. 03-12-2017, 08:59 PM #1
    Surajgk
    Surajgk is offline
    Registered User
    Join Date
    03-12-2017
    Location
    India
    MS-Off Ver
    Office 2016
    Posts
    2

    Transpose a list of related values

    Hi, How to transpose a list of related texts / values? Eg: I have the data as:

    Capture 1.PNG

    Required result is:
    result.PNG

    Please help.

    regards,

    Suraj
    Reply With QuoteRegister To Reply
  2. 03-12-2017, 11:52 PM #2
    NickyC
    NickyC is offline
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Transpose a list of related values

    Hi
    assuming your sales offices are listed in alphabetical order, try this macro. Your will need to set FirstOffice as the cell with the first office name (I have assumed A2) and FirstOutput as the first cell of your output range (first sales office).

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 03-13-2017, 12:42 AM #3
    Surajgk
    Surajgk is offline
    Registered User
    Join Date
    03-12-2017
    Location
    India
    MS-Off Ver
    Office 2016
    Posts
    2

    Re: Transpose a list of related values

    Thank You... Its working
    Reply With QuoteRegister To Reply
  4. 03-13-2017, 12:52 AM #4
    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,945

    Re: Transpose a list of related values

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    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
+ 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)

Similar Threads

  1. if statement in 2nd of two related lists. Can list 2 auto refresh when list 1 is altered?
    By ChrisCD in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-21-2016, 06:38 AM
  2. [SOLVED] Loop through list of unique values to copy & transpose data
    By YOO629 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2015, 04:34 PM
  3. Transpose data into two columns based on two related columns through sheet
    By dylanvv in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-03-2015, 03:42 PM
  4. [SOLVED] Insert row based on a list of comma-separated values in one related cell
    By AEPS in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-31-2014, 10:35 AM
  5. [SOLVED] transpose related data from row into columns
    By Lisa4legin in forum Excel General
    Replies: 6
    Last Post: 11-10-2013, 04:50 PM
  6. [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
  7. HELP on TRANSPOSE related function.
    By sunj99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2005, 11:57 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1