Hi, I have a scenario where I deal with data manipulation in excel with a table having Main and Sub-Headers. Attaching photos for reference.
I need to delete columns from the child table that do not start with “Cases”. But doing so would remove parent column data. The Main table headers also needs to be intact at the same time.
I have tried to find a workaround using datatable and excel operations both, but none seem to work.
Has anyone faced a similar problem statement and knows how can I go about this solution.