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.
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: