Hi All,
I have values in Name & Value column ( first two columns in attached, ) i need to generate the thrid column automatically based on first two columns, I need a formula to generate the values as in Result column.
Name | Value | Result |
test | 123 | test=123;what=231;why=456;when=876;who=654;where=345; |
what | 231 | |
why | 456 | |
when | 876 | |
who | 654 | |
where | 345 | |