Spill from list is returning in columns instead of rows

[xTyD23x]

Hi, I am a beginner, so please forgive my ignorance on some of this stuff!

Here is what I'm trying to accomplish:

I am making a template that will be edited by people in our company. I have a list (in one column), where there will definitely be gaps between the data. I have defined the range for the entire area where something can be entered as "FULL_EQUIPMENT_LIST". I am referencing this list using a Data Validation drop-down on another page. The problem is that the cells that are blank show in the drop down, and I would like to hide them so that it is easier to look at without scrolling through a bunch of blanks.

Here is my current "solution":

I created a second list to bring in all the data from the first list, but ignoring blanks. The plan is to use this filtered list for the drop down, rather than the original. I found this VBA code searching the internet and added it into my workbook:

Please Login or Register  to view this content.

The code works to bring in the data and ignore all blank cells, but when I call it out, it displays the data across columns, rather than rows. I'm not sure why this is the case, since the original data is in one column.

Any help on this would be greatly appreciated. Thank you!!

[Fluff13]

Hi & welcome to the board.
As you are using 365, there is no need for a UDF, you can simply use
=FILTER(FULL_EQUIPMENT_LIST,FULL_EQUIPMENT_LIST<>"")

[xTyD23x]

Wow! I spent a long time trying to figure a solution out for this, and this simple formula worked perfectly. Thank you so much! I really appreciate it.

[Fluff13]

You're welcome & thanks for the feedback.