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 |
Anil KumarPosted Mar 8, 2015, 8:26 AM
You can try
http://www.extendoffice.com/documents/excel/1544-excel-convert-column-to-comma-separated-list.html
Its tried n tested, I used it year back
Vishwas KadamannayaPosted Mar 8, 2015, 6:40 AM
Anil KumarPosted Mar 8, 2015, 5:13 AM
Refer :-
http://www.codeproject.com/Tips/830404/How-to-Get-SQL-Column-Values-as-Comma-Separated-St