Custom List Sort Not Working

[maximiliax]

I have a report I receive that I can't change the way the layout is exported, but I need the columns in a different order. I created a custom list with the column names in the order I need them. The list appears to have imported correctly, and when I type in the first value in the list, and then autofill down, the list autofills exactly the way I expect.

When I try to actually use this list to sort with however, it looks like excel is only taking the first 14 values, and then is sorting the rest of the columns alphabetically, ignoring my custom list.

I've got a workaround in the meantime where I create a new sheet, autofill the list in the order I need, add a helper row to my original sheet with a match function to get the row number from the workaround sheet. I then can just sort by number smallest to largest. But I'd like to be able to do the sort without the extra steps.

Any ideas on what I'm doing wrong?

Im on Office365 for Mac.

EDIT:
I was going to attach a sheet to illustrate, but I'm not sure how. The custom list is below

Time
email
STID
Number of Employees
Name # 1 (First)
Name # 2 (First)
Name # 3 (First)
Name # 4 (First)
Name # 5 (First)
Name # 6 (First)
Name # 7 (First)
Name # 8 (First)
Name # 9 (First)
Name # 10 (First)
Name # 1 (Last)
Name # 2 (Last)
Name # 3 (Last)
Name # 4 (Last)
Name # 5 (Last)
Name # 6 (Last)
Name # 7 (Last)
Name # 8 (Last)
Name # 9 (Last)
Name # 10 (Last)
Tee Size # 1
Tee Size # 2
Tee Size # 3
Tee Size # 4
Tee Size # 5
Tee Size # 6
Tee Size # 7
Tee Size # 8
Tee Size # 9
Tee Size # 10
Special Order Tee Size # 1
Special Order Tee Size # 2
Special Order Tee Size # 3
Special Order Tee Size # 4
Special Order Tee Size # 5
Special Order Tee Size # 6
Special Order Tee Size # 7
Special Order Tee Size # 8
Special Order Tee Size # 9
Special Order Tee Size # 10
Hawaiian Size # 1
Hawaiian Size # 2
Hawaiian Size # 3
Hawaiian Size # 4
Hawaiian Size # 5
Hawaiian Size # 6
Hawaiian Size # 7
Hawaiian Size # 8
Hawaiian Size # 9
Hawaiian Size # 10
Special Order Hawaiian Size # 1
Special Order Hawaiian Size # 2
Special Order Hawaiian Size # 3
Special Order Hawaiian Size # 4
Special Order Hawaiian Size # 5
Special Order Hawaiian Size # 6
Special Order Hawaiian Size # 7
Special Order Hawaiian Size # 8
Special Order Hawaiian Size # 9
Special Order Hawaiian Size # 10

 

[Jon Peltier]

So the accounting system exports the data into some kind of file, and you open it in Excel or import it into Excel.

Use Power Query to import the data (Data tab > Get Data from File). You can easily reorder your columns as needed. Even better, next time you get the exported data, you can just rerun the query.

 

[maximiliax]

I may be confused, but I think power query is limited only to loading data on Office 365 for Mac. I don't think there are any editing capabilities.

 

[Jon Peltier]

Oh, you're using Mac, sorry. Power Query is coming, but slowly.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Sort by Custom List Not Working
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[maximiliax]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Sort by Custom List Not Working
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

I apologize. I'll make sure to do so in the future.