The issue is that your input file is set up the way that I see people tend to use spreadsheets. That is, the layout is designed for humans to read and not for machines. Your initial statement of the problem made it seem as if KNIME was misbehaving when in fact the problem is the layout of your input file.
You’re going to have to do some work to get your input file in the optimal shape for use in KNIME. For KNIME to do what it does best, every row in the table needs to be a unique record, defined by a unique Row ID. Unique column headers define each column, and these are typically extracted from a single row in the source data. In a typical data analytics project, this is usually where most of the work is.
Maybe if you told us what analyses/manipulations you plan on doing and what your desired end result looks like, we’d be able to nudge you in the right direction. Otherwise you’re just going to keep getting seemingly random suggestions that won’t work because there’s some other complication that you haven’t mentioned.
None of this is about coding ability.