New KNIME user trying to understand how to manipulate a Excel table in KNIME. I have the following table format:
|Serial Number||Parameter Name||Parameter Value|
The actual file has 1000's of SN & up to 50+ parameters...
I am trying to figure out how to flatten & transpose (not sure if these are the right terms)? to the following format so I can join w/another file based on SN:
I saw a few other threads on similar topics but they didnt quite fit the scenario I outlined. Would anyone be able to provide guidance on how to get this done?
Thanks in advance