SOLVED

Query from a list into 2 columns, in chronological order

Copper Contributor

Hi

I have a spreadsheet with several columns: apples, melons,  bananas, ... Each column is filled with different dates (see the 2nd tab called "Dates" from link below).

 
How to make ONE list, in a new tab, in chronological order from ALL this data in two columns? In column "A" each time the header name (apple, banana, melon, ...), in column B a date (from its representative row).
 
The result would be a list of all data:
(A1) fruitname; (B1) it's date
(A2) fruitname; (B2) it's date
...
 
Someone who knows how to deal with this?
 
In the 3rd tab there is a example of how it should looks like, made with Google Spreadsheet.
 
All help is welcome!
Thanks.

 

Link to the file:

List of dates - One Drive 

 

1 Reply
best response confirmed by Magenta (Copper Contributor)
Solution
I have added a query to the file (see the link). Note that in order to do so the formulas which gave the headings had to be removed.
1 best response

Accepted Solutions
best response confirmed by Magenta (Copper Contributor)
Solution
I have added a query to the file (see the link). Note that in order to do so the formulas which gave the headings had to be removed.

View solution in original post