Calculate non-empty rows for concatenation

Hello,

So I am having a bit of trouble figuring this out.

What I want to do is calculate how many rows have data in column A (which I have been able to do), but then using that info I then want to concatenate that data with a ", " in between each value (which is where I am stuck). So the VBA should calculate say 3 values (last value in A3, first data always in A1), then concatenate those values (v1, v2, v3) to be copied and special pasted (just values into a selected cell on another sheet) without needing to hard code the formulas on the worksheet.

For the time being I have physically typed in the concatenate formulas (for 2 values, 3, etc up to 6 values - since there is usually not more than 6 for now) and manually select the row with the correct amount of values.

Any help would be greatly appreciated as it would make this project immensley easier.

Thanks,

-BC