Add one lines after a result is satisfied

    MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question



    Add one lines after a result is satisfied

    Add one lines after a result is satisfied
    good morning, I'm looking for a solution to my problem, to make it easier to understand I illustrate with images. we have a SHEET 1 with this data: my goal…
    www.mrexcel.com


    good morning, I'm looking for a solution to my problem, to make it easier to understand I illustrate with images.

    we have a SHEET 1 with this data:

    my goal is to make a given "sheet2" extract this data in such a way that it looks like this:

    basically I need nothing more than a shift of the contents of column B when the value "o" is encountered in column A

    it seemed like a simple thing, but it's not like that (at least for me)

    any suggestions?

    Edited once, last by AliGW: Cross-post links added. ().

  • AliGW

    Added the Label Cross Post

    AliGW


    Thanks a lot for pointing out the CROSS POST ....


    It does Avoid Working to design a solution ... for NOTHING ...!!!

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Carim


    It isn't completely resolved on EF - the OP has, unsurprisingly, shifted the goalposts. The sample really isn't representative.

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

    AliGW


    Honestly ... I have to sympathize with your simultaneous monitoring on all Excel Forums ... ;)


    Quickly checked ... no feedback ... in any of the THREE Forums ...!!! =O

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login