We can build an export definition to output this information on a single line.

Step 1: Build a query of the membership transactions
  1. From Analysis, click Information Library
  2. Click Add a new Ad-hoc Query
  3. Select the record type of Membership
  4. Highlight Membership in the list of Source views and click OK.
  5. Under Browse for fields in, highlight Membership Transaction. In the middle column "Select Membership Transaction fields" drag Action to "Include records where." Set the action to be one of Join, Renew, Upgrade, Downgrade, Rejoin. Here is an example of how the field will look under "Include records where" Membership Transaction\Action is one of Join, Renew, Upgrade Downgrade, Rejoin
  6. Under Browse for fields in, highlight Members. In the middle column "Select Members fields" drag Primary member to "Include records where." Select Equal to Yes. Your field will look like this: Members\Primary Member is equal to Yes.
  7. Use this field if you are examining membership transactions within a certain date: Under Browse for fields in, highlight Membership Transaction. In the middle column "Select Membership Transaction fields" drag Transaction date to "Include records where." Your field will look like this: Membership Transaction\Transaction date between 1/1/2013 and 12/31/13 
  8. Use this field if you want to exclude fully refunded transactions: Under Browse for fields in, expand Membership Transaction, expand Revenue Application, Expand Revenue Details, highlight Sales Order. In the middle column "Select Sales Order fields" drag Refund status text to "Include records where." Select Not Equal To Fully Refunded. Make sure the box is checked to Include Blanks. Your field will look like this: Membership Transaction\Revenue Application\Revenue Details\Sales Order\Refund Status text is not equal to Fully Refunded or is blank. 
  9. Save and Close your query
Step 2: Build an export definition of the output fields you would like to see on these transactions
  1. From Administration, Click Export Definitions
  2. Click Add, 
  3. Select the record type of Membership
  4. Highlight Membership in the list of Source views and click OK.
  5. On the left expand Members, Click Constituents. From the middle move Name to Selected Fields
  6. On the Export Criteria Screen, Filter on Selected Members and move Primary Member to Include records where. Set is equal to Yes
User-added image
  1. On the left, Click Membership Transaction. From the middle move Transaction Date (Date Only) to Selected Fields.
  2. On the Export Criteria screen, Filter on Selected Membership Transaction and move Action to Include records where. Set is one of Join, Renew, Upgrade, Downgrade, Rejoin
User-added image
  1. With Membership Transaction Highlighted in Selected Fields, From the middle move Action to Selected Fields
  2. On the Left expand Membership Transaction, Click Membership Level. From the middle move Name to Selected Fields
  3. On the Left, Click Revenue Application. From the middle move Amount to Selected fields
  4. On the left expand Revenue Application, Expand Revenue Details, Click Sales Order. From the middle move Refund Status Text to Selected Fields
  5. On the Export Criteria Screen, Click Okay
  6. On the Left Expand Sales Order, Expand Sales Order Item Membership, Click Sales ORder Item Membership Item Promotion. From the middle Move Amount to Selected Fields
  7. On the Export Criteria Screens, Click Okay
  8. On the Left, Expand Sales Order Item Membership Item Promotion, Click Membership Promotion. From the middle move Name to Selected Fields
  9. Name your Export Definition and Save
User-added image

Step 3: Create Your Export Process
  1. From Administration, Click Export
  2. Name your Process
  3. In the Export Type drop down, select Export Defnition
  4. In the Selection box, Search and select the selection we created in Step 1
  5. In the Export Definition box, Search and select the export definition we created in Step 2
  6. Save
  7. Run your export process