How to concatenate and format multiple columns

[jeangodecoster]

Hi,
I would like to use an excel formula to generate markup text based on the content of multiple columns, the row header and the column header.
So for example here is the content of my 3 columns:

Character	FR	EN	NL
Charlie	Bonjour!	Hello!	Hallo!

and I'd like a formula that would generate the following markup:

<div class="Charlie">
    <div id="FR">
        Bonjour!
    </div>
    <div id="EN">
        Hello!
    </div>
    <div id="NL">
        Hallo!
    </div>
</div>

Is there a way to do this with a formula? I know I could add 3 extra columns, with a concat function to build the div for each language, and then concatenate all those three, but is there a way to do this with one single function (that would ideally take the range and then apply some transformation to each element in the range, and produce the whole shebang in one fell swoop.

Or do I have to resort to VBA instead?