+ 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, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Transposing part of a column considering the contents

    Here is a VBA solution for you

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  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, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    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)

Similar Threads

  1. [SOLVED] Transposing Data based on cell contents
    By aidan5800 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-08-2018, 08:36 AM
  2. Transposing Columns to Row based on Cell Contents
    By Firestone in forum Excel General
    Replies: 2
    Last Post: 07-09-2015, 04:50 PM
  3. [SOLVED] How do you insert cell contents from one column into another based on a specific part?
    By Cremorneguy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-30-2014, 08:55 AM
  4. [SOLVED] Transposing Row Variables into Columns - part #2
    By BHammy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2013, 11:32 AM
  5. [SOLVED] Importing multiple CSV files and transposing contents into successive rows
    By Strupo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-23-2013, 04:27 PM
  6. Adding column B based on part of column A contents
    By Mornemoz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-24-2013, 03:22 AM
  7. Analyzing cell contents, inserting a number of rows, and transposing
    By james_black in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-15-2010, 11:28 PM

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