How to use Transpose in excel Uipath

I want to copy the data from row A1 to H13 to column B - Transpose. Please help me how to implement transpose through Uipath.


Here is a guide on how to do it in VB.Net but bear in mind that Excel is pretty good at transposing data so would it be better to do it there? i.e. call a macro.

Hi @Sanjna,

Use excel application scope inside the excel application write the formula for transpose



Thanks for your response. It is not working. If you have sample workflow please upload it.

Hi @Sanjna

Here is a detailed article on that :slight_smile:
# How To Transpose DataTable – In UiPath