Complex IF formula help needed

[talkersw]

My first worksheet has a list of projects with Quarter, Partner, Date Live, and Project name. It is in a column style format:

WKSHT 1
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Quarter[/TD]
[TD]Partner[/TD]
[TD]Channel Live Date[/TD]
[TD]Project Name[/TD]
[/TR]
[TR]
[TD]Q1[/TD]
[TD]Company 1[/TD]
[TD]1/1/2018[/TD]
[TD]Project 1[/TD]
[/TR]
[TR]
[TD]Q1[/TD]
[TD]Company 1[/TD]
[TD]2/1/2018[/TD]
[TD]Project 2[/TD]
[/TR]
[TR]
[TD]Q1[/TD]
[TD]Company 3[/TD]
[TD]3/6/2018[/TD]
[TD]Project 3[/TD]
[/TR]
[TR]
[TD]Q1[/TD]
[TD]Company 1[/TD]
[TD]1/1/2018[/TD]
[TD]Project 4[/TD]
[/TR]
</tbody>[/TABLE]

Another worksheet contains a horizontal layout such as this.
The Problem is that when the formula is used and the cell does not = true, it shows a blank cell. What I need is are the blank cells to be ignored and only show the fields with values. The problem is highlighted orange in my formulas shown below.

For example, above in WKSHT 1 in the fourth row would insert a new cell in WKSHT 2 for Company 1 under the Jan 2018 column.

Can this be done?

WKSHT 2
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD] QUARTER 1[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Parter[/TD]
[TD]Jan 2018[/TD]
[TD]Feb 2018[/TD]
[TD]Mar 2018[/TD]
[/TR]
[TR]
[TD]Company 1[/TD]
[TD]IFAND (Quarter = Q1, Partner = Company 1, Month = January THEN show project name,
else " "[/TD]
[TD]IFAND (Quarter = Q1, Partner = Company 1, Month = February THEN show project name,
else " "[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Company 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Company 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Here is a link to get a feel for what Im doing and the formulas I'm using. You can see how I have blanks (highlighted yellow) in the second worksheet. The third sheet is me just finding ways to remove the blank cells.

https://1drv.ms/x/s!AhZV5hTkyQrRekw9CPetpoNBib0<attachment></attachment>

 

[talkersw]

Maybe better question...how can I remove the blanks automatically to push the results to be adjacent, one non black result after the next.

<attachment></attachment>