How to concatenate all cell values in excel and give output in a single format with space

image

In the above image of excel ,i have tried, but didn’t get perfect output what i required.
The output what i want to get is: a,b,c,d,e(between each cell it should be comma)
output 1: a,b,c,d,e
output 2: x,y,z,q,l
can anyone please help me to get output.

@saneeth_kandukuri

how does the input look like currently? when you fetch it from the excel?

basically if you have spaces after or before each letter you can use Stringreplace .net method to replace all spaces with comma

ok tanq for giving hint neonova

You can achieve this by using read data table , then for each row iterate through each column and you can append the string to the previous one like
Var=var+","+col(Val)

can u please sent bot file so that i can analyze.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.