Problem with loops/recorded macro

[yookd]

Hey guys,

I am very new to VBA and I need a lot of guidance to make future reports. Attached are 2 excel spreadsheets.. the one named sample is what the final product should look like and the one named testest is the data I have to modify.

The SQL query spits out info in an unformatted way, as shown in testest.xlsx.

There might be multiple divisions and task summaries and I need something that can handle that as well.

So far, I have just recorded macros and copy/pasted them over to the post-processing tool that HP Quality Center has. The problem with this is that it does not necessarily deal with multiple divisions and tasks.

I need help making this first VBA program.

Thanks.