Query Creation - Table Rearrangement

[Crdmster]

Hey All! I am wanting to create a query which will reorganize an existing table (please see the attached for reference). To summarize, the objective will be to create a query in which I can quickly sort all the tables to view all dates in order and in one column. I would like to do this without VBA if possible, as to eliminate the need of refreshing before printing a report.

Pic.pdf

[Bulzie]

Maybe:

"Select [Project], [Date2] as ProjectDate, "Date2" as Description from Table1
UNION ALL
Select [Project], [Date3] as ProjectDate, "Date3" as Description from Table1
UNION ALL
Select [Project], [Date4] as ProjectDate, "Date4" as Description from Table1;"

[Crdmster]

That did it!

Your a scholar and a champion Bulzie, thanks alot!

[Bulzie]

Glad I could help!!

[Crdmster]

Can someone help with making a Query in the opposite manner then stated above. From the attached picture "Pic.pdf", i want to create a Query to look like "Existing Table" from a Query which looks like "New Query". It's basically my initial question, except backwards.