How to ummerge one cell data in to multiple rows in excel using uipath

Hi Team,

I have one with name as “Sheet2”
In that Sheet2 have only 1 column data is there .

So , i want to write as it is in the “Sheet3” dynamically.

Here I am attaching the excelfile
Data.xlsx (11.4 KB)
Please help me to slove the issue ASAP.

Thanks in advance,

Note: please ignore the “sheet1” data.

I want Sheet2 data format changes into sheet3 format.

Please suggest any solutions.

Baby…

Try using power query (which is an excel function within excel - should find documentation on it on the web) to create the database that reflects how you want the data to look, then use UiPath to move the new files to location that the excel database points to and have UiPath update and sort/filter the data as you need.

Hi @atarantino ,

Thank you for your support.

I didn’t understand, can you please show me how to implement that.

Thanks
baby

https://www.google.com/search?q=how+to+use+power+query&rlz=1C1GCEB_enUS984US984&oq=how+to+use+power+query&aqs=chrome.0.0i512l10.2432j0j7&sourceid=chrome&ie=UTF-8

look for videos on how to set up power query. this will be where you start. then have UiPath refresh the connection.