Is it possible in Open/LibreOffice Calc to take the values from a set of two or more rows, and display them in one column? In order words, make a separate column which derives its values from the original two rows without destroying or altering the original rows and their data.
Also, at the same time, assuming the values in the original two rows are essentially random, can they be placed in order?
Just to be extra clear: I don't mean a one time, manual copy, paste, and sort operation. I mean for the resulting column to contain formulas that will display what is in the original two rows and be updated when the data in the original rows changes.
So, for example, I have the following two rows of dates:
I'd like to reorder them into a column like so:
Is this possible?
Bonus: Can the resulting column have duplicate dates removed? Like so: