I have transposed, using an account number, some data so that a list of flags reads across. I have then put these columns into an array. What I would like help with is:

a) how can make the dimensions of the array to be dynamic depending how many columns end up in the dataset after transposing.

b) how can add the strings in the array together to make one variable.

If possible I need this answer by Monday morning.

Simon.