Switching a row to column and a column to a row

[erinrog]

Hi all! I have data formatted as seen in the screenshot attached but want to make the first column (Company, 1, 3, 10, etc.) into a row and would like to make the first row (GC/TOTAST, GC/CURAST, etc.) into a column. Does anyone know how to do this? I've been trying to use the cross tab tool but haven't had luck so far.

[alexnajm]

Columns to Rows - Transpose

Rows to Columns - Crosstab

A combination of the two tools will likely do the trick!

[erinrog]

Yes, that's what I figured but can't actually figure out the execution. Do you know what these inputs on the side should be? Having trouble figuring out the values for new columns field because I want to keep all the rows, not just one. 

[alexnajm]

It's hard to recommend a solution without knowing what the final output should look like - if you can provide a sample of the input and of the expected output, it'll be easier to work with.

Otherwise I recommend opening the sample workflows for the Transpose / Crosstab tools to better understand how the configurations work!

[erinrog]

x

[alexnajm]

Can you include the data? I don't want to retype all this myself :)

[erinrog]

Here it is! And overall end goal is just trying to get the format to look like this

[alexnajm]

I'm sorry, this is now too confusing as there are multiple bits of conflicting info. Please clarify:

• There are multiple tabs in the Help file - which tab am I using as the input?
• You have now specified multiple output formats in two different responses - which format is the end goal?

Also at this stage, better to just get the workflow - please go to Options > Export Workflow and send the .yxzp. If you are not comfortable with this, I am not sure I can help further - my advice of the Transpose andthe Crosstab should still work.