How do I convert my data into a table like this?

I am doing a literature review and at the moment I have a table where I am listing all articles and ticking of their "theme", "theories used" and "methodology" like this:

How_do_I_get_from-this.jpg

Now I need to map the theories onto the articles, like this:

to_this.jpg

How do I accomplish this? (in an automated manner, obviously)

I hope the pictures are sufficiently self-explanatory, it is kind of hard to explain what I am trying to achieve otherwise. Note that ticking boxes is accomplished by changing the font to wingdings 2 and using uppercase P for checking a box. I know there are real checkboxes for this purpose, but I am generating the table from imported data and can't find another way to program excel to tick boxes if a condition evaluates to true.

Go to this link to download the original file:

https://dl.dropbox.com/u/706446/Semi..._template.xlsx

Need more clarity on this