I Hope you are well.
I have this excel sheet and I want to split it on two excel Sheets or Two DataTables.
First Should Contain Everything Up to The Yellow Lines without including them, meaning a certain row will be emtpy.
Second File will Read below the yellow lines until the next yellow lines where the rows are still emtpy.
Please guys advice.
Should I use a for each row, and copy the row to another data table if the particular column value is not empty?