Insert blank rows between existing rows based on cell text.
New to Knime and was wondering how to insert blank rows based on cell value from an existing Excel file, I have created a sorter. In excel I have created a program button to do this. Stumped on how to do this in Knime. Any help would greatly be appreciated.
Example if excel sheet Cell c2 through C6 would have “giant”. Cell C7 through C8 would have “mini”. Cell C9 through C16 would have “small” . And so on. Goal is to insert blank rows between each change in size. Is it possible?
Thanks Bill