Transpose data

[hlmnsbuggy]

Crystal 2008, odbc
I have a claim table with layout as this

Claim # Enter date NOTE TITLE
XX19000008 01/08/2010 ACORD1
XX19000008 01/31/2010 ALAE Expense
XX19000008 02/09/2010 Reserve Change

ZZ24000164 12/07/2009 CLAIM
ZZ24000164 12/22/2009 Replacement
ZZ24000164 12/22/2009 Examiner review

How can I transpose the info by enter dates to show the info as below instead in crystal.
Claim # NOTE TITLE
XX19000008 ACORD1 ALAE Expense Reserve Change
ZZ24000164 CLAIM Replacement Examiner review

Thanks for your help

Ann

 

[hlmnsbuggy]

I found LB's advice from thread149-1529329 about how to flatten table. It worked perfectly.

Thanks LB

Ann