How can I do this process

Help Activities
1

I want to copy some data from one Excel sheet and paste it into another. The problem is that I want to transpose the data from rows to columns. The data I want to copy is in Sheet 1, all in the same row, and I want to paste it in Sheet 3 but in the form of a column, keeping the headers and copying all the row data. I am attaching an example of how it should look
image
I also want to copy all the data from ‘Start Date’ and paste it for every new row that is in Sheet 3.

2

@ingenieroit.mantelingenie

You can use copy paste range activity with transpose option

The image contains a bullet point describing the "Transpose" option, which rotates the copied range of cells from rows to columns and vice versa, and is not selected by default. (Captioned by AI)
The image contains a bullet point describing the "Transpose" option, which rotates the copied range of cells from rows to columns and vice versa, and is not selected by default. (Captioned by AI)828×165 54.3 KB

Cheers

3

Hi, I want to paste the date in each column in sheet 3, how can I do it?

4

@ingenieroit.mantelingenie

What do you mean by each column? as per screenshot there are only two and transpose shouold do

did you even try it?

cheers

5

Hi @ingenieroit.mantelingenie ,

You can achieve it by using invoke code activity. I have attached the solution, please check if it works.
You need to pass the values for variables as shown in the screenshot and run the code.

The image displays a code editor within a software application showing a code snippet for manipulating Excel files using Microsoft Office Interop and variable definitions for workbook path, source sheet, and destination sheet. (Captioned by AI)
The image displays a code editor within a software application showing a code snippet for manipulating Excel files using Microsoft Office Interop and variable definitions for workbook path, source sheet, and destination sheet. (Captioned by AI)1072×428 53 KB

TransposeExcelData.zip (49.0 KB)

6

I mean, the document I am working on is a compilation of many Excel files, and I want the ‘Start Date’ data to be copied for each row. When I finish and start adding data from the next Excel file, it should continue placing the data in the next column where the previous one ended. I have no problem with the regular compilation since the program automatically places the data, but I’m not sure if the new function will work the same way.
image

7

@ingenieroit.mantelingenie

You need in new column or row?

Also while psting you would be the one specifying the start range can specify as you need

Dynamixally can calculate which column or row is empty by first reading the data and then use it further to paste

Cheers

8

In the next row sorry, thank you for your help

1 Like
9

@ingenieroit.mantelingenie

So you can read the data and get row count …or can copy to a new sheet or intermitted sheet then read the data after transpose and then use append range

Both the above methods work

Cheers