transposing data + importrange function (GoogleDocs)

Hello,

Can someone please shed some light on how i can work with this document.

The first tab of the below document contains the raw file. The second tab is where I need to work on collating (sum) the raw data.

I was wondering if there is a way that i can input (on Sheet 2 cell A2) a formula and just drag the fill handle towards the end of the columns so that it will capture the sum of the data in reference to the names in Tab 1.


Also, using the importrange function in Google Docs, is there a way that I can import an entire sheet BUT align all the text/data in just one column in the new sheet?

I hope I am making sense.

Anyone, please?

Thank you so much!