I have a spreadsheet that looks similar to this (only many more rows on the actual). Notice how on line 20, there is a line break and the same data is repeated after the break.
I will have a DataTable with a list of items that I want to paste into the “Item” column here. So say my list of items is:
I would want to paste each item into the “Item” column, and then once at the line break, paste the next item, and so on. So it would look like this:
Does anyone have any ideas on how to automate this process? Thanks!