Icon

Column Header Based on Two Rows

This workflows shows, how the values of the first two rows can be combined and used as column headers.

Read exampletableExtract the firsttwo rows with the column headervaluesReplace missingvalues with the previousvalueCombine the two parts of the column headersApply the new column headersExcel Reader Row Splitter Transpose Missing Value Column Combiner Insert ColumnHeader Read exampletableExtract the firsttwo rows with the column headervaluesReplace missingvalues with the previousvalueCombine the two parts of the column headersApply the new column headersExcel Reader Row Splitter Transpose Missing Value Column Combiner Insert ColumnHeader

Nodes

Extensions

Links