Create a Constituent or Gift export in a relationship/table-based format like Access or Crystal Report.
 

  1. If you need this information in Excel, after exporting to Access, select File, Export within Access and choose Excel as the format.
  2. In the export parameters, select Tools, Export Options. 
  3. Mark the Export one-to-many records in separate tables checkbox.
  4. Click OK. 
  5. Select the appropriate field. When prompted for the number of records to export, leave it blank.
For Participants:
Export the participant information by creating a Participant Export instead of an Event export.