+ Reply to Thread
Results 1 to 4 of 4

Transposing part of a column considering the contents

  1. #1
    Registered User
    Join Date
    06-18-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    76

    Transposing part of a column considering the contents

    Hi all,

    For better explaining the problem, I attached the short example. Please kindly take a look at the file and let me know how I can obtein the desired output, which is specified with blue color in the same sheet of file. Here, there are two columns, A and B (black color) as input data, which Y2, and Y3 is related to A1 and should be transposed to generate desired output (blue color). However, I have a large dataset and manullay transposing each part is really time-consuming. Could you please provide me a formula for doing the work?


    Thank you
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    15,256

    Re: Transposing part of a column considering the contents

    Here is a VBA solution for you

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-18-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    76

    Re: Transposing part of a column considering the contents

    Many thanks, it works well.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    15,256

    Re: Transposing part of a column considering the contents

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks for the rep

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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