Help needed on a formula

[shreked12]

I have this formula that I copy down the page but the issue im having is where im copying the data to if either cell in original cells are blank it putting a 0 in and I need that blank

=INDEX($BA$1:$CT$1,ROWS($A$6:A28))&" "&INDEX($BA$2:$CT$2,ROWS($A$6:A28))

lets say BA3 has something in it and that copies OK but lets say BA4 is blank cell it putting a 0 where im copying formula to.

Id there anyway to avoid it posting a 0 when the data cells are empty?

 

[Logit]

.
This should work :

[COLOR=#333333]=IF(BA1="","",INDEX($BA$1:$CT$1,ROWS($A$6:A28))&" "&INDEX($BA$2:$CT$2,ROWS($A$6:A28))[/COLOR]