Need Formulas to Hide Partial Concatenate Data and Help Determining Two Other Formulas

Hello All!

I'm trying to automate creating certain keyword combinations I need, based off of the values I input into reference cells in columns A - E; the goal is to compile a list of keywords which I will then use to track my rankings in search engines. But there are three things I simply do not have the smarts to figure out, and I was hoping someone in here who is a bit more seasoned with excel formulas could provide me with some guidance. Below is what I am trying to accomplish:

1. I'm looking to only output 500 keywords, so some of the cells in columns A, B, C & E will not contain data (column D will always have a primary Geo-target listed). This results in some of the concatenate formulas I've created outputting partial data (i.e. if there is no data in cell A10, and cell D2 contains the word "Knoxville", then cell I10 will output the data, "Knoxville "). How can I setup conditioning formatting or a formula so that these auto-generated cells appear blank if one of the reference cells has no data within it?
2. The reason why I need the above to work is because I want to setup a formula that automatically counts the # of keyword combinations created by the data entered into any of the reference cells. With the partial combinations being listed, it skews my data. Which leads me to my next question: what is the best formula for counting the # of cells containing a full keyword combination from any of the cells listed in columns G - O (minus the data in the header cells; i.e. G1, H1, etc...)?
3. Lastly, is there a formula I could use that would then aggregate all of the full keyword combinations within the "Complete Keyword List" column (column P)?

Hopefully the above explanations and requests are not too confusing and/or difficult. I've attached an example document (click here: Ranking Reports - Automated Keyword Template.xlsx), which will hopefully increase my chances of getting some help on this one.

Thank you for your time and consideration, and please let me know if anything else is needed.