How to pull data and leave no blanks

[Noxqss38242]

BREAKDOWN-DOWNTIME.xls
	Z
65493	Road Repairs Occupied
65494	UNIT
65495	20251
65496	16854
65497	16826
65498	20361
65499	20720
65500	16912
65501
65502
65503
65504
65505
65506
65507
65508
65509
65510
65511
65512
65513
65514
65515
65516
65517	Road Repairs Empty
65518	UNIT
65519	20542
65520
65521
65522
65523
65524
65525
65526
65527
65528
65529
65530
65531
65532
65533
65534
65535
65536
makes-models trucks down

Cell Formulas
Range	Formula
Z65494:Z65515	Z65494	=IF(ROWS(Z$65494:Z65494)>$AB$65493,"",INDEX(Sheet1!$A:$B,ROWS('makes-models trucks down'!Z$65494:Z65494)+$AA$65493,COLUMNS($Z65494:Z65494)))
Z65518:Z65536	Z65518	=IF(ROWS(Z$65518:Z65518)>$AB$65517,"",INDEX(Sheet1!$A:$B,ROWS('makes-models trucks down'!Z$65518:Z65518)+$AA$65517,COLUMNS($Z65518:Z65518)))

So the list is always changing. I want to list Z65495 thru Z65515 ONLY if data are in the cells
AND list Z65519 thru Z65536 ONLY if data are in the cells

Thus I want cell:
M65505: 20251
M65506: 16854
M65507: 16826
M65508: 20361
M65509: 20720
M65510: 16912
M65511: 20542

So it would ignore that Z65501 thru Z65515 was blank and then picked up on Z65519 and again ignored the blanks thru Z65536.

If they were not blank, they would be listed, if blank, do not list blank.


Any suggestions?

 

[jsb1921]

pl post the sample result you want. if Z65495 thru Z65515 is not blank, where do you want to put them. can you somehow make use of

isblank(a1)

function