Hi everybody!

I'm new to this forum and I was looking for some help using macros.
My scenario is like this: I have an Infopath form with some repeating tables in it, for those who don't know, the fields from a repeating table appear all merged in one same cell. So when I export this form to Excel I got all my information from diferrent rows all merged in one. They have a dilimeter between them which is an Indentation.

I've attached an example so you could see the .xlsx I get from Sharepoint.

What I'm trying to achieve is split every field into different rows, for example the column "Dia Nro" should have three rows with, 1, 2 and 3 respectively.

Sorry if I wasn't clear enough but English is not my native language

Hope somebody can help me, I would really appreciate any help!

Thanks for reading!

Have a nice day.

fer22.


example.xlsx