Is there a way to concatenate a range of cells?

I have a list of data of about 3000 cells in a column in excel.. I would like to combine these cells in groups of about 500.

Is there any way to accomplish this?
Thanks