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.

[alexnajm · Accepted solution]

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

[gagnew]

You are spectacular.  Thank you for entertaining and solving my rookie question!

[alexnajm]

Happy to help!