First time posting so a picture of the excel sheet is attached to the hyperlink.
I would like to format my weather data as seen in column P. The column would go, first cell (# of days in month”,”Three letter Abbreviation of Month”-“last two digits of year). Then combine column M and column E in that order with a comma delineation below it for each day in the month. After each month is has been completed, I would like to insert a row with the next months information as stated above (# of days in month”,”Three letter Abbreviation of Month”-“last two digits of year).
There is roughly 10,000 rows of data. I believe I will have to use a Macro or Conditional Formatting but do not know how to write this out. The row insert is not important as long as I can drag the formula down the column and still get the right corresponding Precipitation and Temperature Average numbers with the dates.