Wordpress Export and manipulate data from SQL

We want to export entries from a special post type (woocommerce orders) from a specific category. All entries are stored in database columns. We sell workshop tickets. People can buy multiple tickets and have to write down the name of the attendee during checkout. Therefore some orders do have just one, some five or even more attendees. Each attendee is stored in a separate column. We want one clean list with one row each attendee. Please check both Excel files. One is the current export using WP All Export. One is the wished result. You can either create a plugin or extension/function for WP All Export (which we would prefer). So the export result will be the "wished_result" Excel.