Split merged cells from Infopath - Sharepoint

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

Thank you very much protonLeah! That's amazing!

This really safistifies my needs, but I'm gonna ask you something else if you could help me. Is it possible to just order the values in the same table instead of copying the values down there? That would be the perfect solution!

Anyway thank you for reading and for you help!

fer22.

Thank you very much!!! That's what I was looking for!

Awesome job protonLeah!

Thanks again!

Have a nice day!

fer22.

Originally Posted by fer22

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.


Attachment 324131

Hello fer22,
I am new at forum and searching a solution to my problem which is similar to yours. The problem I have is when I export repeating table field (which contains Text) to excel it separates items with ;#
How can i set up a macro for this.
For those who will reply and deal with this issue, thank you very much.

Hi,

I know this is reviving a very old thread, however the function shared by "protonLeah" is exactly what I'm looking for with 1 exception. My excel file has multiple rows already. If I use the macro shared, it actually overwrites my existing data. How can it be modified so it pastes the data below any current rows.

Thanks!