convert

[supiansyarif]

Dear all

i'm use excel 2013
i wan convert data vertical to horizontal plus add coma

NT01

NT02

NT03

SS01

SS02

SS03

to become 'NT01','NT02','NT03','SS01','SS02','SS03'

thank
supian

 

[shaikhrulez]

Enter this in new cell
=TRANSPOSE(A3:A8)
select A3:A8 and press F9. You will have what you want, copy and paste the array output.

You may replace the special characters as desired through Find and Replace.

 

[supiansyarif]

Enter this in new cell
=TRANSPOSE(A3:A8)
select A3:A8 and press F9. You will have what you want, copy and paste the array output.

You may replace the special characters as desired through Find and Replace.

how do I just comma just one, as below
'NT01','NT02','NT03','SS01','SS02','SS03'
not like
"NT01","NT02","NT03","SS01","SS02","SS03"

thanks,
supian

 

[shaikhrulez]

As stated above, through Find and Replace (Ctrl+H)