Merge cell data not copy paste in excel

Help Studio
1

Hello Friends,

I am trying to copy paste data and column A have merge data.
See below screenshot

image
image426×234 4.36 KB

I have to filter data if column B=10, I need those data. I have used filterdata table but it shows like in below screenshot.

image
image386×149 2.55 KB

Column A is blank no facility details available.

Can someone solve this issue?

2

Hi @Jeeru_venkat_Rao
Please find the attached solution
Sequence.zip (63.4 KB)

The image shows a UiPath Studio workflow in design mode, featuring activities such as reading a workbook, assigning values, looping through rows, and writing a line, with active view of the Immediate panel displaying variable contents and debug details. (Captioned by AI)
The image shows a UiPath Studio workflow in design mode, featuring activities such as reading a workbook, assigning values, looping through rows, and writing a line, with active view of the Immediate panel displaying variable contents and debug details. (Captioned by AI)1920×1027 101 KB

The image shows a spreadsheet with two columns labeled "Facility" and "Code," listing three entries: two for "HouseKeeping" and one for "Electrical," all associated with the code "10." (Captioned by AI)
The image shows a spreadsheet with two columns labeled "Facility" and "Code," listing three entries: two for "HouseKeeping" and one for "Electrical," all associated with the code "10." (Captioned by AI)922×606 10.3 KB

Please mark as solution if its working

3

@Akash_Javalekar1
Thank you Akash, Its working fine.

1 Like
4

Great I am glad to help you

Happy automation

5

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