suggestions on creating this chart

[JessiDarklighter]

I have gestational diabetes. Because of this I have to go through the torture of pricking my fingers 4 times a day and save the readings of the glucose meter. If that wasn't bad enough, the nurse that I have to email once a week wants the data sent in a specific format. I need to make a table that looks like this...

date bef bkfat aftB aft L aft supper
date # # # #

I store my glucose readings in an iPod app, which I can then export to a .csv. I have been working in excel trying to get the pivottable to give me the right results, but because my input looks like this....

Type Value Unit Name Event Date Time
BG 108 mg/dL Out Of Bed 5/27/2011
BG 112 mg/dL After Breakfast 5/27/2011
BG 106 mg/dL After Lunch 5/27/2011
BG 100 mg/dL After Dinner 5/27/2011

I keep having problems in that excel does not merge the rows with the same date heading. I'm afraid this is far beyond my ability to program myself. Any suggestions?

[Mordred]

Because it is difficult to assess exactly how code should be run to extract and then store data from .csv, it may help us if you could create a mock workbook that contains your desired results and the data coming from the .csv file (that you can paste right into say, sheet3).

[MarvinP]

Hi Jess,

You need to have your data in a Table with the words only in row 1. See the attached.

I think your csv file should have only 5 fields of numbers. The first is the date and others are you readings.

[JessiDarklighter]

here is an example of my exported csv and the desired result...