0

This question already has an answer here:

In a Google Sheet, I have multiple tables containing a list of dates. I want to create a single (sorted) list containing all the dates and the table they came from.

Table foo:
1.1.19
3.1.19

Table bar:
2.1.19
4.1.19

Result:
1.1.19 foo
2.1.19 bar
3.1.19 foo
4.1.19 bar

Is this somehow possible with regular formulas or do I need to switch to custom functions here?

marked as duplicate by Rubén, serenesat, jonsca Jun 18 at 21:44

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

0

=ARRAYFORMULA(SORT(SPLIT({
 QUERY(IF(LEN(A2:A), A2:A&"♦foo", ), "where Col1 !=''", 0); 
 QUERY(IF(LEN(C6:C), C6:C&"♦bar", ), "where Col1 !=''", 0)}, "♦"), 1, 1))

0

Not the answer you're looking for? Browse other questions tagged or ask your own question.