I need some help transposing data I am getting from a simple web query into a more organized form.

Take a look:
https://www.dropbox.com/s/wo1tdpbhp7...ry%20Test.xlsx

The data that I am getting from the query is displayed on Sheet1 (take a look at the query to get an idea of what the source table looks like). I want to take that data and organize it so that it neatly and automatically fills into the columns I have set up in Sheet2.

Is there a way of taking the individual cells from the table import of the query and organizing them on Sheet 2?

An important note: the table that is selected by the web query is updated regulary - new entries (studies) are added and removed periodically. I need it so that the organized table in Sheet2 is automatically populated when that does happen.

Thank you!