Transpose and filter

You've been asked to pivot all metrics and dimensions other than EmployeeNumber in order to make a key-value pair table. A key value pair table is fast, flexible, and scalable. It is fast due to having only two columns. It is flexible in that any type of data can be added. It is scalable because new dimensions or metrics can be added without changing the structure. The EmployeeNumber will serve as the primary key. Once this is complete, you'll look at how to filter to a specific dimension and value in the new table.

If you've lost progress, don't worry. We are starting with a freshly loaded dataset!