Convert Data Structure from Table to single row line items to get unique IDs

gagnew

"Amount" data is currently organized in a table with "Location" identifier vertically and "Department" identifier horizontally.  This is causing an issue as a single Alteryx Record Number contains "Amount" data by the "Location" identifier for multiple "Departments."  Ultimately would like to transform my data so that each Alteryx Record Number only contains "Amount" data for a single "Location" and a single "Department."  Screenshots of current data state and desired future state are below.  Any help would be greatly appreciated.

Amount by Location and Department.xlsx

alexnajm

Try the Transpose! Key field is Department, and all your other columns should be Data fields