Using a Macro to Reformat or Copy/Paste to new Format

I have an exported report from Salesforce which is very difficult to read due to the formatting when exported. As there are multiple people using this report and with all levels of experience in excel I wanted to create a template which would allow the user to correct the format to make the data usable.

Here is the link for the file: http://ift.tt/19jFsv8

I have set it up that the user copies the export onto the 'Data' tab, and then the macro would run to move it to the 'Output' Tab.

I want the 'Account Name' to move to column A and then the data (white rows) to be copied in next to it. There are some columns which don't need to be copied though - Column K and the blank ones - M, R.

Any help would be much appreciated!!