I am trying to merge two columns in a table into one column in a new table in the following format:

Table1a

I am trying to get the new table column to combine the two columns so that it stores the values in the following format:

<div>
    <verse type="v" label="1">
        <tag name = 'eng'>
                this is the first line`</br>`this is the second line`</br>`This is the third line`</br>`This is the forth line
        </tag>
        <br/><br/>
        <tag name = 'spa'>
                sta es la primera línea`</br>`esta es la segunda línea`</br>`Esta es la tercera línea`</br>`Esta es la cuarta línea 
        </tag>
    </verse>
    <verse type="v" label="2">
        <tag name = 'eng'>
                This is the fifth line`</br>`this is the sixth line`</br>`Gthis is the seventh line`</br>`this is the eight line
        </tag>
        <br/><br/>
        <tag name = 'spa'>
                Esta es la quinta línea<' BR'>esta es la sexta línea`</br>`Gesta es la séptima línea`</br>`esta es la octava línea
        </tag>
    </verse>
    <verse type="v" label="2">
        <tag name = 'eng'>
                this is the nineth line`</br>`this is the tenth line`</br>`this is the eleventh line`</br>`this is the twelveth line
        </tag>
        <br/><br/>
        <tag name = 'spa'>
                esta es la novena línea`</br>`esta es la décima línea`</br>`esta es la undécima línea`</br>`esta es la duodécima línea
        </tag>
    </verse>
</div>

<slide> is used to define a new verse and the verses are incremented by 1
And every time it is supposed to be nested like this.

   <verse type="v" label="Increment_by_1">
        <tag name = 'eng'>        </tag>
        <br/><br/>
        <tag name = 'spa'>        </tag>
    </verse>

I have tried combined using string manipulation functions such as CAST, ||, INSTR, and SUBSTR but none of them have been working in my favour yet.