Data transpose

Help Studio
1

my data is in another sheet
1-thu 2-mon 3-sun…

I want paste this data in another sheet like…
1-thu
2-mon
3-sun…
please help…

2

@Shubham_Akole you can use Data transpose activity. Refer this Data Manipulations - RPA Component | UiPath Marketplace

1 Like
3

but how If any workflow available then please share me…

4

Is your data spread across multiple column OR it’s space separated string? Do you mean to say you want to convert columns into rows?

5

yes convert row into column but paste into another sheet

6

@Shubham_Akole Please find attached xaml Sample.zip (21.9 KB)

7

Step 1: Use Read Range activity to read data from sheet1
Step 2: Transpose data using Data Transpose activity (link given by @inp)
Step 3: Use Write Range activity to write data to sheet2

Reference Thread:

8

@Shubham_Akole
Check this workflow,
Test.xaml (7.8 KB)

1 Like
9

Write Range: Invalid column index (256). Allowable column range for BIFF8 is (0…255) or (‘A’…‘IV’)

this error

10

@Shubham_Akole Have you given extension to .xlsx

11

yes…

12

This workflow is work…
but This is not work in my excel file…
when transpose is done then all data in excel file is delete and then tranpose data is paste…in other file…
Any solution… to prevent my data