Sorting multiple columns by High, Medium, Low

Hello all

I'm trying to sort multiple columns which all have the same values (High, Medium, Low) so that when I visualise them they show in order of severity. I can do it for an individual column by creating a table and using that to sortby but the new column will only sort one column. Equally, if I create a new table and column for each one I wish to sort, I get a message saying ''There can't be more than one value in 'New column' for the same value in Risk 2' (where New Column is the column created to establish the hierarchy of H,M,L).

The data looks something like this:

Location                       Risk 1     Risk 2        Risk 3          Risk 4          

Country 1                    High       Low           Medium      High             

Country 2                    High       Medium    Low             Medium        

Country 3                    Low        Low           Medium      Low

Can any body help? THere must be an easier way to do this! All I want is to be able to sequence the axes in my visualisations by H,M,L rather than alphabetically or numerically.

Many thanks.