I am trying to create multiple sections of columns on a spreadsheet
where I have =IF(C2=1,SUM(B2:B2),"0") in column D2. This formula will
either fill in column D with a string of numbers or 0. From this
output, I am then taking that data and using the formula
=IF(D2="0",A2,"") to copy data to column A63. What I want to do now is
take the output in A63:A119 and remove any cell that is not filled with
actual data so that I am only left with the list with no empty cells
inbetween. Is there a formula that will allow me to do this?

I have attached a portion of the sheet I am working on for reference.

Thank you


--
Dallas101