Hello Everyone,

I have a complex InfoPath form that gets uploaded to a SharePoint form library. This form (for those that have experience with InfoPath) contains a repeating table, which results in the form library displaying the data in the repeating fields (in this case multiple order positions, each with their own description, price per unit, quantity, etc., fields) in one cell when performing an extract from SharePoint to excel.

It seems very complex to solve in InfoPath, and it seems more feasible for me to attempt to separate the data that has been merged into one cell by InfoPath/SharePoint using a Macro in Excel. However, InfoPath does not provide delimiters in the extract, although an indentation does appear between what should be the 2 rows of information (please see attached example).

SP Extract Example.xlsx

What I would like to achieve is:

ROW1: PO # (unique identifier); Quantity; Etc.
ROW2: 29; 50000; etc...
ROW3: 29; 40000; etc...

And not:

ROW1: PO # (unique identifier); Quantity; Etc.
ROW2: 29; 50000¶40000; etc..

I would very much appreciate any help here. As am not experienced with macros, I would be all the more enthusiastic about a code that I could copy in

Many Thanks & Best Regards