Hi Jim,

Thanks for your prompt reply and recommendation. I'm not very advance
when it comes to using Excel, can you explain how to do that? I
stumbled across the SNAKECOLS webpage
(http://www.mvps.org/dmcritchie/excel/snakecol.htm) but am unclear
which macro/function will serve my purpose.

Regards,
Greg

Jim Thomlinson wrote:
My recommendation would be to rearrange the data as follows:

Date SunRise SunSet MoonRise MoonSet
Jan 1 8:00 20:00 17:00 7:00
Jan 2 ...

From here you can pivot the data with a pivot table,allowing you to
reorganize the data to appear however you want. Keep in mind that the days
running across the columns will not work as there are 365 days and only 256
columns...
--
HTH...

Jim Thomlinson