I am running a SQL statement and writing it to an excel file. Once that completes I want three of the columns to write to another excel file and be in the same column in the new excel file. I did a read activity from current excel sheet columns “B2:C39” then write to new excel file “I9”. Instead of columns B and C writing to the new sheet’s I column it just writes it to column I and the next column J. Does anyone have any advice on how I can get each individual value in columns B and C to write to my new excel sheet column I.
Please take a look this thread.
in the cell range give like this “A:C”. it will copy the entire column.
Video explanation :
hi, do you know how I can write more than one value to a single column?