VBA code to concate a range and have a ; as the divider between the values

[drop05]

I am trying to concatenate values from a range in column A from row 1 to row 81 with a "; " to be between each value in the concat, i am not sure how t to get it done in an easier way than

"=CONCATENATE(RC[-1],""; "",R[1]C[-1],""; "")"

 

[alansidman]

It is not listed manually. The code actually is recorded similarly to how the Macro recorder works. In PQ, one would highlight the field to be transposed and then click on the Transform tab and then click on Transpose. So in reality, it is really quite simple. PQ, then takes those steps and creates the code as shown.

 

[Peter_SSs]

Would you really have to list them all individually like that?

Not manually, individually. For example, if there were 5,000 rows, it would make for very long code?

 

[alansidman]

Peter. You are absolutely correct. It would make for very long code.