I have an excel sheet which has both merged and unmerged cells like shown below
when i try to export to a datatable using ExportToDatatable option, i am geeting the out put as shown below
How to get the Mgr1 in the 2nd Row aslo(which colored in orange).
I have another excel sheet,which has data as shown below
Expected result is
how to get the result
please provide the possible solution asap
Thanks & Regards,