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
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)