Sorting problem

Is there any way to load multiple lists on same page or Is there any way to create a sub-sort ?

Here's my problem; I have a list based on a specific filter. Within that list I want to list leaders in a specific order (CEO, CFO, MANAGER, etc.). Seems I can only list by alpha ASC or DESC. I've tried to change field values numerically and leave the values as their title descriptors, but it doesn't change anything. 

Is there an Advanced Sorting solution to this?

Advanced Sorting lets you sort your list by directly altering the userlist SQL. Sounds like you need advanced sorting. Simply select it as the sorting option under the Sorting tab in your userlist and provide the needed ORDER BY SQL. Examples are provided in the description of the advanced sorting textarea parameter.

When I use the example in tooltip it works great. However, I can't seem to get the query to pull the columns fields I want

I can't help you with that. I've no idea what your column fields are or how exactly you're wanting to display them. You'll need to write the necessary SQL for that. You've full access to the ORDER BY clause of the SQL in Advanced Sorting so you're only limited by what SQL supports there.