Multiple values in one cell separated by commas

[tsm1111]

I have a huge table (over 400 columns, with up to 200 rows of data) that is composed of columns that have different number of rows with values (Column A contains data in rows 1-59, column B in rows 1-129). I want to create cells in Column A -> Z that combine values from rows non empty rowes separated by commas, but only if the value exists, so I do not get multiple commas when joining cells that are empty when using formula =A1&","&A2&","......Any ideas?

 

[Joe4]

Just save it to the Macro-Enabled version (.xlsm).
It is one of the Save As options.

 

[Tobbes]

Is it possible to do this with myRange but only selecting every nth column or cell?