Lookup Table custom sorting?

[roattw]

I have a lookup table I would like custom sort order - not alphabetical.  In the Table I was hoping to see a Move Up/Down option for the field in the table datasheet view.  But there wasnt one.  Do I need to delete the existing fields and re-enter in the order I want?  Or maybe do a custom lookup Both in field option source?  Both seem clunky if I could just order them right in the master table. Thanks!

[MayMusic]

Easier would be to export it in excel do the arrangement and then import it back to Caspio to replace with the existing table

[roattw]

Thanks MayMusic.  I presume on re import the existing captured data would follow the rearranged rows?