Extract Table data rows to collumns

[Povilas_Jonikas]

Hello guys, I have a problem that don’t know the answer to. When I take data form webpage, it outputs like this: 1 Collumn 45 rows. Is it possible to do 45 Collumns 1 row?

[KRISHAN_JINDAL]

Can you please put the screenshot of the webpage, how exactly it is populating there?

[Chirag_Shetty_Divakar (Chirag Shetty)]

How to Transpose Excel data or Data Table?

Hello UiPathans Here we discuss how to Transpose the data in Excel or a data table What is meant by Transpose? Input [image] Output [image] Transpose can achieve by two methods → Modern activity- Using Copy/Paste range Activity.(For Excel Processing) → Novigo Solutions. (For Datatable Processing) Modern activity- Copy/Paste range Activity. By Using modern activity we can achieve the transpose method. For classic users can select Show Modern from the Activit…

[Povilas_Jonikas]

Sure here it is

[Povilas_Jonikas]

Ok, so I achieved my goal in a way by using transpose data table method. But then I ran into a different problem.
The data that i’m getting from web is in multiple rows but in one collumn. Copy paste range with transpose data table works fine, it puts the info in one row and in many collumns, but the problem is, that the robot has a loop, because it needs to get more than one data table. When I get another batch of information from web, it yet again puts it in the first row of and in multiple collumns, but could it be achieved, that it would append the range into second row, then third and so on?

[supermanPunch (Arpan)]

@Povilas_Jonikas

it yet again puts it in the first row of and in multiple collumns, but could it be achieved, that it would append the range into second row, then third and so on?

Hi @Povilas_Jonikas ,

It seems that you are using the Write Range Activity also for the Second and further iterations. Could you apply a check and if it is the First Iteration use Write Range Activity and if it is other than the first use Append Range Activity.

You could use the For Loop activity’s Index property to get the iteration value.

[Povilas_Jonikas]

Thanks for the response Apran. But actually im using write data table to excel and Copy/paste range with transpose data window checked. This was the easiest way for me to achieve data transposing. But now the problem is that the data still comes out not as i want it to. Would it be possible to loop row 1, row 2 and ect by using theese activities?