Power Automate Desktop Copy Excel Column to another Excel Column

[Melone]

Hello all,
I am just starting with the topic RPA and Power Automate and I am still quite inexperienced. I have a problem. I am trying to automate a process for work. I have attached example photos.

Excel file 1 = Only the table with all the information

Excel file 2 = A prefabricated layout (table entry starts from A14).

I would like to insert every single column from Excel file 1 into Excel file 2. In reality, it will have much more data, so I would insert each column separately.

My problem is that I can't make it so that every single column is automatically read and it does it automatically until the table is completely read.

Thanks a lot ! 🙂 

[VJR]

Hi @Melone 

The example photos did not get attached to the post, So I couldn't get clarity on your requirement.

To know the last column with data, you can get it from the below action.

[Melone]

Hello,
enclosed is the sample photo.

I have tried it with the activity first Column. But it only manages to transfer the column that I have defined before. It does not read the other columns automatically. I think I started my flow completely wrong.

Before I started automating. I thought it would be easy because it was logical. Now I doubt my abilities 😄

[VJR]

- Open Excel File 1. Lets call this as ExcelInstanceFile1

- Find the last row using "Get first free column/row from Excel worksheet". Lets call this variable as LastRow

- Copy cells from Excel worksheet from A1 to LastRow - 1 of A column

Then in Excel File 2 with ExcelInstanceFile2

- Paste cells to Excel worksheet into C14

Do the same for other columns.

If you want to do it a bit more dynamic then in File1 Search for the text "Name" to get the Name column (using Find and replace cells in Excel worksheet)