I have a sheet like this:
I want it to have two columns:
out with the corresponding values:
I'm able to do so using sorting and copy-pasting, but as the data gets more complicated this way gets more complicated, and less safe, as well. Maybe there is a simple, correct way for such a transformation?