data from rows and column to one single line

[iscar_marius]

I have to worksheets: Sheet1, Sheet2
In sheet 1, I have some data like this (in first col is 1, second col is a, third col is c etc. ) :

1 a b c d
2 e f g h
.
.
.
.

I need in sheet 2 in range A1(only in this range one big text), something like this:

a,c,e,g ........ ( row1-col2,row1-col4,row1-col2,row1-col4 ......) ( separated by ",")

The number of rows from sheet 1 is variable.
The dataf a,b,c,d,e,f,g,h ... is some random text.

How can I do this automatically ? Please help.

[iscar_marius]

Any ideaa?

[iscar_marius]

Please open attached file.
I added some code:

Please Login or Register  to view this content.

This code will add in column Q the values that I need.

Now I need to create an string that will concatenate all the values from column Q and add this string in a cell(1,1) from sheet 2. Please help me to do this.
Thank you.

[StephenR]

Try this:

Please Login or Register  to view this content.

[iscar_marius]

Exactly what I need. Thank you!