I've created a spreadsheet that has a user form for people to input project information and time length. This information is fed into a project database spreadsheet.

This is what the Project Database looks like:
http://imgur.com/ZuQQRVS

And this is what my Project Calendar looks like:
http://imgur.com/8SZ6Ler

I'm using an =IF(ISNUMBER formula to check for "Yes" or "No" values under Q1-Q4 and it pulls the Project Name + Name into the cell field.

Now I'm wondering, for example in Row 4, Q1 and Q2 have the same value, is there a way to merge them together and have them represent the Project Name + Project across Q1 and Q2? Maybe a macro of some sort that wouldn't ruin the formulas contained in each cell?

I've been Googling around and haven't had any luck just yet.