Concatenating a column of data

[gazmond]

Hello,

Before I start apologies if this has been asked before all I can seem to find is threads on concatenating rows and/or not dealing with spaces, after a couple of searches its now started returning an SQL error!

I am hoping someone can help with concatenating a column of data into one long comma seperated string.

I have attached a spread sheet with a column of data in column D (numbers) that I want to concatenate into one long comma seperated string in Cell E1. The column of data sometimes has empty cells that will need to be ignored, also the column in the real spreadhseet I have used hs many more columns than the example I have atttached so making it stop when it reaches the word STOP or somesuch would be be handy. Can anyone help? The examples I found so far I can't seem to get my head around so any help would be much appreciated.

Many thanks in advance

Gaz