Excel formating from SharePoint List / Infopath

[TonyO76]

Hi –

I have a SharePoint list which is populated by an InfoPath form. On completion of the form, it is printed as a PDF.

The fields within the form are set up something like this;

ID
Name

Food
Category
Comments

Food
Category
Comments

Food
Category
Comments



The data held within the list is exported to Excel for analysis against all other forms in the list.

A new row is produced within Excel for each form submitted, so the data is presented as follows

ID	Name	Food	Category	Comments	Food	Category	Comments	Food	Category	comments
1	John	apple	fruit	green	carrot	vegetable	orange	salmon	fish	pink

<tbody>
</tbody>

For the purpose of analysis I need the data to be shown as follows.

ID	Name	Food	Category	Comments
1	John	apple	fruit	green
		carrot	vegetable	orange
		salmon	fish	pink

<tbody>
</tbody>

I have looked into the following options without much luck;

• Send the Data to MS Access, format a report and export to Excel – problem is that the report does not retain its formatting when exported.
• I have looked at some formatting options in Excel including creating pivot tables and slicers from the raw data.
• Looked at changing the SharePoint List views, and InfoPath controls

The restraints I have are as follows.

• The data must be collected from a SharePoint list.
• All data must collected in the same form.
• The data has to be exported to Excel for analysis.

Hoping someone can offer some advice.

Thanks in advance.