Displaying values in the next available cell

[TWienholz]

Good morning everyone. Does anyone know if there is a way to fill in a range of cells based on info from another range of cells but have them fill in so that there are no blank cells in the starting range? Pardon the confusion, but I have a formula that reads as follows:

=IF(AND(OR('Data Sheet'!M37=TRUE),(OR('Project Data Sheet'!H21={"Small - Adult/PRE-NOTICE","Small - Adult/English","Small - Adult/Spanish","Large - Adult/Eng-Spa","Small - Adult/Custom","Large - Adult/Custom"}))),'Project Data Sheet'!B21," ") (B22 corresponds to 9138001, B23 corresponds to 9138002, etc.)

and shows the following result placing project numbers in their corresponding cells:

Sample Number(s):	9138000	9138001		9138003	9138004	9138005
	9138006			9138009
							9138014

<tbody>
</tbody>

For the cells that are empty, i.e., where 9138002, 9138007 and 9138008, etc. would have been placed had they met the criteria, is there any way to close up these gaps so that I don't have gaping holes in my project number list and so that the next number that does meet that criteria would display in the next available cell instead of being locked into one particular? I hope that makes sense.

Any assistance would be greatly appreciated.

Thank you so much!