CrossTab list or Arrays???

Good day to all,

I have this list (small sample presented) in Excel 2013

The list needs to be transformed/transposed in order to build named ranges for a Cascading Lookup Function (up to 64 ranges - "Locations") - i.e. the cells filled with colour

Here's a small sample: Workbook1.xlsx.

Wondering what the best method is here.

Thanks!