Transpose with multiple sheets without duplicating columns
----------
Hi there -
I am trying to combine several versions of the same Excel form so that the column structure is permanent with the information added underneath (my data input). Questions in the Excel forms are listed in one column, with responses in the next column. My desired data output is an Excel form is a table where each question is listed as a column header with the corresponding responses below from every form.
External resources
Used extensions & nodes
Created with KNIME Analytics Platform version 4.2.0
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
Legal
By using or downloading the workflow, you agree to our terms and conditions.