jeangodecoster
New Member
- Joined
- Dec 16, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- MacOS
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:
and I'd like a formula that would generate the following markup:
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?
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:
HTML:
<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?