Combining repeating fields
I have two repeating fields which I want to combine into one. I tried by concatenating but that added repeating field 1 of the first repeating field to repeating field 1 of the second repeating field.
Does anyone know how to do this simply within the same file?
Or is the only way to export, use a text editor and import, or use a script (which I can use but I'm not skilled enough to write this one).
Any help gratefully received.