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.

TIA

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.

https://bytes.com/topic/visual-basic-net/answers/365297-transpose-rows-columns-datatable

Hi @Sanjna,

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

=TRANSPOSE(A1:H13)
cf8dcd533a6ab06db2dbb8d2a356f30dc5382603_1_451x500

Regards,
Arivu

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

Regards,