how to combine column data

[rehanemis]

Hello,

I would like to combine 2 columns data into one column as shown below.

Col 1--- col 2
12 checking
13 operating
12 non checking
14 simplify
12 Nill

The Result should be as:
12 checking, 12 non checking, 12 Nill
13 operating
14 simplify

any idea how to accomplish it.

 

[CJ_London]

see the concatrelated function here

http://allenbrowne.com/func-concat.html

 

[mikejaytlabustro]

Please take a look on attachments for specific solution in your question.