Columns merging in same excel file

excel

#1

Please guys i need your help,

i am new to the tool and i just wanted to know how i can merge two columns (firstname and lastname) in the same excel file, and add the merging to the result file under column (name)

Ex:
firstname : abd
lastname : elrhman
name(in result file):abdelrhman

Main.xaml (10.2 KB)
project.json (288 Bytes)
Result.xlsx (8.7 KB)
RPA Task.xlsx (8.2 KB)


#2

extract the datatable, then within a for each row on that datatable, use the write cell activity with the range of “C”+theDt.rows.indexOf(row).toString and value of row(0).toString+row(1).toString. you can adjust it however you want, depending on the position of the columns.


#3

Can you please be more specific, i cant quiet understand half of the commands you mentioned.

Thank you for your reply


#4

i entered this but it gave me an error:

“C”+DataTable1.rows.indexOf(2).toString


#5

I applied what you said but when i select the column it starts from cell number 10,
even when i type “E1” it starts form E10 and if i typed E2 it starts from E20.

thank you.