Move columns based on blank/non-blank cells

Working on an underwriting model. Have a 100 column data range that fills cells based on an anchored cell.

At the end of the range, in the 101st column, I have a check. I would like the columns to adjust based on which ones are actually filled.

i.e. If 44 of the 100 columns are filled, I would like the check cells to move to 1 column after, in this case, the 45th column.

Is this possible?

Perhaps there is a more elegant solution out there, which I would welcome learning about to, but this is one approach:

In B1:
=if(and(A1<>"",A1<>[check cell formula],C1=""),[check cell formula],"")

Then drag this across all rows.

Then enter the data in columns as needed. In so doing you will be overwriting this formula.

When you get to the end of your data set, in the next column over the check cells should appear.

The formula essentially says, if the column to the left has data (not including the check cell formula), but the column to the right does not have data we are at the end of the data set so put the check cell formula.