I have data stored in an excel sheet in the following format. Column 1
contains a location. Columns 2-3 have values for day 1, Columns 4-5 have
values for day 2, etc... One set for each day of the month. There is a
seperate worksheet for each month. I would like to automate something to put
all of the data on one sheet in only 5 columns. Column 1 Location, Column 2
Day, Column 3 Month, Column 4-5 the values. I have built this to transport
into access but it takes way to long. Any help in the most efficient way to
do this in excel?