D. Add a Location Code column following the below argument
E. Sort all data from Lowest to Highest based on the  Location Code values above
F. Add a Style column following the below formula:
    LEFT(VALUE OF STYLE CODE COLUMN, 8)

Done publishing the new version.