Removing Column Blanks and Producing New List

[gazharry1]

Hi everyone,

Please could someone explain how to populate a list of all the cell values, excluding blanks, from under a column header. For example if there was column A and column B, each with 4 selections under each, including some blanks, how would I be able to complile a list of the cells values under a chosen header (ie A or B), defined using a drop down list??

Column A Column B
Val1
Val2 Val3
Val4
Val5 Val6

Edit - The website removes the spaces in the table above. Under Column A is Val1, Val2, blank, Val5; Column B is blank, Val3, Val4, Val6)

Drop down box - Column A selected, would return the follwing list (starting in C1 and finishing in C3)

Column C
Val1
Val2
Val5

Thanks,

Gary

[gazharry1]

Edit - Column A is Val1, blank, blank, Val2, Val5