Date mentioned in a row of an excel has to be updated in a column of different excel sheet

Hi All,

Dates which are present in a single row of an excel sheet has to be updated in a single column of another excel sheet. Please help me if anyone knows how to perform the process

1 Like

@Ashika_Raj Can you elaborate more on what exactly you are trying to achieve.

@Ashika_Raj

we have few topics to transpose the data table or excel.check this

https://forum.uipath.com/search?q=transpose%20excel

1 Like

I have an excel sheet (input) in which the first row has a dates for the entire month … For ex- 1 sept to 30 sept.
image
I want the dates from the row to be written column wise
image

Thanks for the link. but I did not find any information which I require

any idea on the above topic?

@Ashika_Raj

Column headers or 1st row of the excel?

@Ashika_Raj

Check the workflow, this is just to read the row of data you have and write it to the column dynamically upto 25 columns. if you have more than 25 rows of data, you need to write another if condition. do let me know if you want that

Ashika.xaml (8.2 KB)

1 Like

HI @Ashika_Raj
here you go with the xaml
rowcol.zip (16.8 KB)

Cheers @Ashika_Raj

1 Like

@Palaniyappan and @HareeshMR

Thanks for your help … I did not get desired output for Ashika.xaml. Working fine for rowcol.xaml

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.