Assistance with Transposing Excel Data

[mlauber71]

@MRWA4687 here is an example where trips are identified based on rules

Label data rows based on column values & calculate measures for each label group

@Er3n you could take a look at this example trying to identify the trips [image] The relevant Column Expression goes like this: if (equals(column("Counter"),1) && // && means AND ( isMissing(column("Status")) || isNaN(column("Status")) // || means OR ) && equals(column("Total cumulated distance"), 0) ) {column("rank")} else {toNull("")}

If you have a way of finding the start or end of you blocks you can mark them by this and handle them in a loop

Move head rows to a column

@willy_oracle typically you would mark all lines with a Counter. Then identify the ‘headers’ with a rule engine [IF Col1 LIKE “Head*” => Counter] and keep that (starting) row in a separate column. Then you fill the missings with the previous value so a block would emerge marking the data table: [image] So now you have the blocks marked an can use a Table Row to Variable Loop Start – KNIME Community Hub or Group Loop Start – KNIME Community Hub to do something with the blocks (export them delet…

To close a loop you can collect the results with a loop end.