Read specific column A value and write on particular cell B1

[GouthamVijay]

This thread may help you,

Concatenate Rows Items into one String

Dears, I want to Concatenate Column Items into one String, as per the below example: Input : Column A item 1 item 2 … … item n Desired Output : output= “item 1”;“item 2”;“item 3”;…;“item n” Thanks in Advnace