@ppr , Thanks for your instatnt response, from your expression I can get what i expected, but only 2 columns only I’m able to get data.
In case of multiple columns having same row data values except one column(which has different data) how can use your Expression and add the different data string. Same scenerio I already mentioned above, That is 2 column, I need it for 7 columns, where 6 columns are unique and 7 th column is Different data , need to add all string in single cell and remove other
I attached my sample Excel sheets here , it contains 2 sheets of input and output sheets
Sample (4).xlsx (9.1 KB)