CONCATENATE and IF Function Issues

I'm trying to take a column of data that contains either course information (with text), or just the number 0, and string together the values that do NOT equal 0 from that column into ONLY one cell on another tab.

Ex:

[*COLUMN A*]
COURSE B8001
COURSE B8002
0
0
COURSE B8003

^ I want to take this column...
and turn it into this...

Cell 1: COURSE B8001, COURSE B8002, COURSE B8003 (all under the same column, just in one cell)

I have been using the concatenate and if functions to no avail and am stuck.

Appreciate any help