Copying rows excluding blanks

Welcome to the forum!

In L5:

=IFERROR(INDEX(A:A,SMALL(IF($B$5:$B$23<>"",ROW($A$5:$A$23)),ROWS($A$1:A1))),"")

In M5:

=IFERROR(INDEX(B:B,SMALL(IF($B$5:$B$23<>"",ROW($A$5:$A$23)),ROWS($A$1:A1))),"")

... both confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Then drag copy down.

You can adapt these for the other columns.

A way to see what a formula is doing is to use the Evaluate Formula feature which is on the Formulas tab of version 2010, so I hope it is still the same on the 365 version. You'll see that the $B$5:$B$23<>"" part of the formula produces an array of true's and false's. That array is then combined with the numeric values produced by the ROW($A$5:$A$23) part to yield an array of numeric values and false's. The last part, ROWS($A$1:A1), tells the SMALL function which number to pick so that the INDEX function gets the correct row from column B. I hope that this helps.
Let us know if you have any questions.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.