I thought I would let you all see how I solved this. I used a group_concat which reads multiple rows into one one long string field row until the group_id field changes value. It also separates fields with a comma for my excel import, and lastly I entered the label for the field as “name,address,city,state,zip” (without the quotes) which then allows me to import the first row as column labels. It all works well.
Thanks to Scott and others who made suggestions.
Mike
SELECT GROUP_CONCAT(element_value) as Name
FROM wp_formmaker_submits GROUP BY group_id