Excel copy data from a workbook to another workbook to a single column

can anyone help me to solve this task where workbook1 contains 10 rows and 10 columns when copying data to workbook2 all the data should be in a single column having several rows can anyone suggest me please

I would suggest to read data from workbook1 and put it into DataTable, then using “for each row” simply merge strings from all columns into one string and put it as a row to a new DataTable containing only one column and at the end write that whole DataTable into workbook2 using Write Range activity.