Hi,

I have say about 10 columns. Now each cell on the columns has data starting with numbers ( 1,2,3,4,5 ) or alphabets. What i want to do is to check all columns in a row and all the values that start with alphabets should be concatenated in one column, values starting with "1", concatenated in another column and etc etc for 2, 3,4 and 5 on the same row.

Any ideas? Please check the attachment as well for a more clear idea of what i am trying for.

Thanks in advance.

sortedbasedonstartingcharacter.xlsx