Are you saying that you want A1,B1,C1,C2,C3? And not A1,B1,C1,A2,B2,C2,A3,B3,C3? If you want something different, please give us a list.
One simple way is to check each cell's Value property and if it equals "" ( an empty string), then don't add it to the array.
I would create a Range from the selected cells, and then iterate the range to add cells to an array. If you select the cells with your mouse, as you did in the picture, you can right click and select "Define Name". This creates a named range. You can also create a Range object in code.
Can't find what you're looking for? Ask the community or share your knowledge.