Copy cell till first empty cell

Hi everybody,

I have an excel file like this bellow an I need to copy and paste the depo value in a desktop app. Can be 0, 1, 2, 3,…n depo. How to copy the values with for each row till the first empty cell?

old account new account depo1 depo2 depo3 depo4
ABCEUR3520514 ABCEUR3520714 DEPO001 DEPO002 DEEPO003 DEPO004
BCDEUR2360484 BCDEUR6924584 DEPO011 DEPO022
EFGEUR6920578 EFG6920514 DEPO111 DEPO222 DEPO333
HYZEUR6284887 HYZ5682014 n/a

Thanks in advance,

Dorin
Test1.xlsx (8.5 KB)

Hi @dorin,

Here is an activity to copy the excel into the clipboard. After that you can past it anywhere

Regards
Balamurugan.S