How to view repeated table contents as column in my sharepoint

[LDUintern]

I am designing a sharepoint for our training unit. Now I used a repeat item
control for the users filling out the form to be able to select more than one
training. However, when they submit a form having used this repeat item
option, I only see the first training they selected in my sharepoint column
(in the form library). What shall I do so that I can see all the items in the
repeated section in my form library column. My intent is to export it to
excel for an easier view.

Thank You

 

[Clay Fox]

That is a common issue with SharePoint. It is not relational.

Typically the best scenario is to use a backend database for the information
(which is relational) and can capture the child elements. Then you can also
use Excel to connect to the data table for analysis.

Another option is to designate a set number of choices. 1,2,3,4,etc and then
promote all of these fields to SharePoint flatly. if that works.

If you would like to see an example let me know.