I probably should know how to do this but i can't figure it out. I have a
database with patient codes in up to 20 columns. I want each row to sort the
data that goes across the 20 columns. for example: (using numbers saved as
text)

PatA 1 5 4 3 2
PatB 5 4 1 6 7
PatC 8 7 3 2 1

Would look like:

PatA 1 2 3 4 5
PatB 1 4 5 6 7
PatC 1 2 3 7 8