I have data that is being collected in an Access 2003 .mdb by date. There are as few as one to many records on any given day. I need to transpose the row data so that the date is in the first column, then a number of columns is generated to include the value for that given day. In the sample data, for example, I am including Impact score which ranges from 0 to 100 in 20 point increments. At the end of the last column, I want to add a "count" or total for that given day, an "average" for that given day, then the "standard deviation" for that day."
I am looking for some VBA to query the data and remove any dates that have missing values, then transpose the data and add the count, average, and standard deviation for that day. I've attached the sample data that is on the same sheet, both the source and the hand transposed data just under the source.