To read the row from one excel and save it as columns in another excel

[ray_sha]

Hi,

I’m trying to read a Excel1 and fetch the details from it.
After fetching the details i.e the rows from excel1,
I want to save it as columns in Excel2.

Attaching the screenshots.
Input: Excel1

Output: Excel2

Thanks in Advance!

[supermanPunch (Arpan)]

@ray_sha Can you check this Activity :

Novigo Solutions - Transpose DataTable - RPA Component | UiPath Marketplace

[ray_sha]

Hey @supermanPunch,
Thanks for the reply.

I don’t want to transpose it.

As I take the rows from excel1,I perform some activities and get an output.
When I get the desired format in excel2, I save the output in cell below 1, 2, 3, 4, 5 in excel2

[ray_sha]

Hey

Is this possible ???
Is there any solution??

[supermanPunch (Arpan)]

@ray_sha

As I take the rows from excel1 ,I perform some activities and get an output.
When I get the desired format in excel2 , I save the output in cell below 1, 2, 3, 4, 5 in excel2

@ray_sha Can you give some other examples as well, As per the Screenshots given above, it looked like a Simple Transpose, but if it is not what you needed, then can you explain more with some other data

[ray_sha]

sure @supermanPunch,

I’ll do that.
Thanks

[ray_sha]

Hey @supermanPunch,

Please find this,
I’ve tried my best to explain:

Excel automation for getting the desired output

Hey all, I have two excels, one is input and other output. I’m trying to achieve the below conditions. For every person in that Department, I want to add 1 in the output sheet for that column I’ll attach screenshot for better understanding INPUT: [image] OUTPUT: [image] Can someone help me? It would be of great help! Thanks in Advance!

Sorry for the confusion and Thanks much!