Get all data

Hi People

Hope you are doing well.

I have automation that requires your help.
The 3 cells in the first column were merged and I need to extract the corresponding cell values.
please help me in retrieving the data.
Image for your reference.

Thanks in advance .Happy automation.

image

Ciao @komal.v.konduru

Merged Cells will as far as I know always be read in the top row.
You could create a read range and just write the data from first row to second and third row?

Of course this solution only works, if it’s always like in your screenshot.

Something liked this worked for me, but is very simple:

Hi @iamNairda

Can you please share the code? I want to explore more on the code

Sure, please find attached the zip file
BlankProcess1.zip (9.5 KB)

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