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