SOLVED

Query from a list into 2 columns, in chronological order

%3CLINGO-SUB%20id%3D%22lingo-sub-870328%22%20slang%3D%22en-US%22%3EQuery%20from%20a%20list%20into%202%20columns%2C%20in%20chronological%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-870328%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20have%20a%20spreadsheet%20with%20several%20columns%3A%20apples%2C%26nbsp%3Bmelons%2C%20%26nbsp%3Bbananas%2C%20...%20Each%26nbsp%3Bcolumn%26nbsp%3Bis%20filled%20with%20different%20dates%20(see%20the%202nd%20tab%20called%26nbsp%3B%3CEM%3E%22Dates%22%3C%2FEM%3E%20from%20link%20below).%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EHow%20to%20make%20%3CSTRONG%3EONE%20list%3C%2FSTRONG%3E%2C%20in%20a%20new%20tab%2C%20in%20%3CSTRONG%3Echronological%20order%3C%2FSTRONG%3E%20from%20ALL%20this%20data%20in%20%3CSTRONG%3Etwo%20columns%3C%2FSTRONG%3E%3F%26nbsp%3BIn%20column%20%22A%22%20each%20time%20the%20header%20name%20(apple%2C%20banana%2C%20melon%2C%20...)%2C%20in%20column%20B%20a%20date%20(from%20its%20representative%20row).%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EThe%20result%20would%20be%20a%20list%20of%20all%20data%3A%3C%2FDIV%3E%3CDIV%3E(A1)%20fruitname%3B%20(B1)%20it's%20date%3C%2FDIV%3E%3CDIV%3E(A2)%20fruitname%3B%20(B2)%20it's%20date%3C%2FDIV%3E%3CDIV%3E...%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3ESomeone%20who%20knows%20how%20to%20deal%20with%20this%3F%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EIn%20the%203rd%20tab%20there%20is%20a%20example%20of%20how%20it%20should%20looks%20like%2C%20made%20with%20Google%20Spreadsheet.%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EAll%20help%20is%20welcome!%3C%2FDIV%3E%3CDIV%3EThanks.%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELink%20to%20the%20file%3A%3C%2FP%3E%3CP%3E%3CA%20title%3D%22List%20of%20dates%22%20href%3D%22https%3A%2F%2F1drv.ms%2Fx%2Fs!AgWrZLxs43BqiAONETjZ841zpihg%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EList%20of%20dates%20-%20One%20Drive%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-870328%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-871566%22%20slang%3D%22en-US%22%3ERe%3A%20Query%20from%20a%20list%20into%202%20columns%2C%20in%20chronological%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-871566%22%20slang%3D%22en-US%22%3EI%20have%20added%20a%20query%20to%20the%20file%20(see%20the%20link).%20Note%20that%20in%20order%20to%20do%20so%20the%20formulas%20which%20gave%20the%20headings%20had%20to%20be%20removed.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted
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.