Overwrite in a column the data corresponding with another column

Help Studio
, ,
1

Hello there,

i tried to copy from one file into another file the data, but now the first column doesn´t correspond anymore with the rest of the data. Does anyone know on how to change that?
If you look at the picture below, the third column was copied. At the beginning it has 3 letters. Now the first column has to correspond to these 3 letters.

image

Kind regards!

2

It seems this is a one-time problem, and also not Studio-related.
Maybe you could achieve this simply using Excel formulae such as CONCAT and others.

Is this an output you are trying to get your bot to achieve? In that case, you could use string manipulation on values in each column, before writing the datatable to Excel.