I am attempting to create a report that looks as so:

Client Name      Date of Service                 Screened for Trial            Trial Available                   Trial Offered

Jane Doe             1/1/2013                              Yes

Jane Doe             1/1/2013                                                                              Yes

Jane Doe             1/1/2013                                                                                                                              No

John Smith         2/1/2013                              Yes

John Smith         2/1/2013                                                                              No

John Smith         2/1/2013                                                                                                                              No

Is there a way to place all of this data on one line so it would look as follows?

Client Name      Date of Service                 Screened for Trial            Trial Available                   Trial Offered

Jane Doe             1/1/2013                              Yes                                         Yes                                         Yes

John Smith         2/1/2013                              Yes                                         No                                          No

The data for Screened for Trial, Trial Available and Trial offered is an Obs_ID#, which has been created as a formula to turn a number ID into text.