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