gistfile1.txt

Franchise  Compound   Study   Milestone Name   PPRC Flag  Protocol Flag  FSFD Flag   Date    # Subjects    
HCV        222        001     VX222-001        No         No             No          5/3/10   1000
HCV        222        001     PPRC             Yes        No             No          1/1/10
HCV        222        001     Protocol         No         Yes            No          3/1/10
HCV        222        001     First Subj       No         No            Yes          5/1/10
HCV        222        002     VX222-002        No         No             No          5/3/10   250
HCV        222        002     PPRC             Yes        No             No          1/3/10   
HCV        222        002     Protocol         No         Yes            No          3/3/10
HCV        222        002     First Subj       No         No            Yes          5/3/10


And what I want to see is this:
Franchise  Compound   Study   # Subjects PPRC Date  Protocol Date  First Subject Date  
HCV        222        001     1000        1/1/10     3/1/10         5/1/10
HCV        222        002     250         1/3/10     3/3/10         5/30/10
etc. (one line per study #)

I have the ability to restructure the data if it's necessary to write a query.

THANKS!
Denise