data transposition

[razzy]

Hi all, i am trying to make a data transpose of the excel file in the workflow getting rid of all the F columns, and transforming rows as columns . Can someone help in getting around this. Thanks

[CharlieS]

Could you provide the Excel file from the Input tool? It would be attached on its own, or you could create a yxzp using Options > Export Workflow.

[razzy]

Thank you very much for responding. See attachment, i just need to transform every row to a column.

[danilang · Accepted solution]

hi @razzy 

Here's a workflow hat transposes your data.  Any time you have multirow headers in your input data, you have to get that down to a single row without losing any of the header info.  That's what the "Build composite header" stream does.  The it unions with the data, renames the columns to the header values, transposes and splits the composite headers back into distinct ones.

Note that your input data has 2 blank rows that show up as Null under the Muscle group column

Dan