I have an InfoPath form table with repeating rows. The columns are 'Members' and 'Departments'. Users can add as many members as they need to. The final resting place for this process is a list called 'Project Results'. Within 'Project Results' is a column for 'Team Members'.
What I'm getting now is: TomBobSally - FinancePersonnelTechServ
What I want is: Tom - Finance, Bob - Personnel, Sally - TechServ
Please advise how I get the looping to format correctly.
Thanks.