Excel Forming of Large Data Set

An excel file of salary data will be provided. There's information pertaining to salaries in specific jobs and cities on Sheet 1. We need someone to compile all the information into one table preferably using macros. There's an example of the table we want on Sheet 2. We would like the script and the final result. Need project completed within the next 2 days.