Convert one table into several tables

Hi there, I have a table with columns: employee ID's, hours amounts, and wage types. I created a pivot table to break wage types into their own columns listing hours and amounts. But I need each...