Switching a row to column and a column to a row

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.

Transformation

Accepted answers

All comments

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

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703