Convert data within column to make multiple columns and convert data within column to rows

Hi everyone,

I have attached an example of what I am trying to achieve with my data set. I want to take the data within a column and make them all into columns, and I also want to make the data within another column, rows.

Any help would be much appreciated!

Example.PNG

Workflow

Accepted answers

CharlieS

A Record ID and Cross Tab tool can take care of that for you. Check out the attached solution and let me know if you have any questions.

20180913-CrossTab.yxmd

CharlieS

Use a Unique tool that has the "Manufacturer" field checked. It will return all columns of data, but only records that have unique values for Manufacturer.

All comments

CharlieS

A Record ID and Cross Tab tool can take care of that for you. Check out the attached solution and let me know if you have any questions.

20180913-CrossTab.yxmd

Chirag_Gandhi07

Thanks, that worked great, but I have a problem. The data I want to make columns, contain duplicates. I want to get rid of the duplicates and only display the value once in the column. I used a summarize tool and grouped Manufacturer, but it only displays that column so I can't connect it to the crosstab tool. Do you know how I could have it so the manufacturer grouped by column stays along with the name column so I can use the crosstab tool?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703