How to use Transpose in excel Uipath

Help
1

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

2

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.

3

Hi @Sanjna,

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

=TRANSPOSE(A1:H13)
cf8dcd533a6ab06db2dbb8d2a356f30dc5382603_1_451x500

Regards,
Arivu

4

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

5

Hi @Sanjna

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

Regards,