Horizontal Sort

  • Thread starter Thread starter ksusong
  • Start date Start date
K

ksusong

Does anyone know of a way to do a Horizontal Sort? I know it sounds odd
but i have a list of 972 rows where the information in each row needs to
be in alpha order. Column A is not to be part of the sort

SPLITRR Rep1 Rep2 Rep3 Rep4
H001 CA01 CK21
H002 6858 CA01
H003 6918 6920 6919 CA01
H004 6875 CA01
H005 1144 CA01
H006 1894 RM08
H007 6133 CA01
H008 CA03 CT79
H009 CA03 CK56
H016 CA04 CT79
H021 BA07 6990 CA06

Thanks!
k
 
Hi
When you go to Data/Sort there is an Options button where you can set the
sort to be Left to Right.

Hope this helps.
Andy.
 
Back
Top