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 | |