Very often tables are presented in Excel files in a non-normalized form. I have one such table which I wish to take into (somewhat) First Normal Form using either SQL commands in Access or, preferrably, some feature of Excel or Access. This would make the data more tractable in pivot tables and just about any real application.
Here's an example of the type of conversion that I want to produce, the first table being the one to be converted, and the second being the expected result:
edit: Let's also say there are enough dateX columns so that doing manual Union queries isn't practical.
I know I could easily do it with VBA or manually appending the columns, if the table weren't big, but I'm interested about the two possible solutions that I mentioned above.
Thanks a lot!