I know the title is hard to understand, so let me elaborate on this.
I have an excel sheet with data like the following.
As you can see, there are lots of space under Name column.
But you can easily tell A3 through A5 are also of Michael’s.
Likewise, A7 is of Tony’s, A9 through A11 are of Kevin’s, and so on.
I used Read Range and retrieved a DataTable object from it, but it has, of course, spaces where it has spaces in the Excel sheet. Now I want to somehow modify the DataTable object so the result of Write Range from the DataTable object will look like below:
How could I achieve this in an elegant way?