I have a table I need to sort the most efficient way:
Table looks like:
Host Comp Sim
HCR 17 SCR 10,
HCR 18 SCR 8,
HCR 19 SCR 13,
HCR 21 SCR 17,
HCR 28 SCR 19,
HCR 29 SCR 22,
HCR 3 SCR 1,
HCR 30 SCR 23,
HCR 32 SCR 24,
HCR 34 SCR 28,
HCR 36 SCR 27,
HCR 39 SCR 31,
HCR 4 SCR 3,
HCR 7 SCR 6,
HF 1 HF 128, HF 48, SF 58,
I need the sort on Host to be by Bill Type and then by numerical order.