I am currently working on a sheet (similar to Sample Sheet 2 in the provided sample workbook) that gathers information from another sheet (Similar to Sample Sheet 1 in the provided sample workbook). The information is gathered based on certain criteria, as you will be able to see in the formulas on Sample Sheet 2. At this point, I have figured out how to gather the information, but I would like a formula that eliminates the empty cells between names in Sample Sheet 2. In other words, if the criteria has not been met, rather than show a blank cell, I would like it to show the name of the next cell where the criteria has been met.

Thanks!

Let me know if there are any questions.

Sample Sheet.xlsx