"Reverse Crosstab" query/table

M

Mike

Hi All:

I have an imported MS Excel table whose columns are titled:

Date
LocationA
LocationB
LocationC
LocationD
......LocationX
and the cell contents under each "Location" shows a price for each
corresponding date.

I want to "normalize" this into an Access table with the fields:
Date
Location
Price

This is in effect the reverse of a CrossTab Query, but of course, there's no
such query function to do this.

Any ideas how to create and populate this Access table from the existing
imported/linked Excel table, without doing a whole bunch of cutting and
pasting?

Regards,

Mike
 
Top