Pivot - Convert Rows to Columns

I have a data set that needs to be pivoted to work with it. Each person has a separate column in the table and all of the data for the person is in the column. I need to transform the table so that each person is in a row and the data for the person is in multiple columns in a single row.

If I were doing this in SQL in a database, I know exactly how I would do it either manually or using a Pivot clause. But, I can't figure out how to do it in Alteryx. The Transpose tool is giving me multiple records per person, each with a different piece of data. I've also tried playing with the Cross Tab and Arrange tools, with no success. I'm obviously overlooking something. Does anyone have any thoughts?

Datasets

Accepted answers

markcurry

Hi @DellChristy

I've attached a sample workflow, so hopefully that's along the lines with what you are looking for. If not, can you post an example of your dataset.

There is also a Totally Transpose macro that might help too.... https://community.alteryx.com/t5/Engine-Works/Totally-Transpose-like-totally/ba-p/30222

Mark

Transpose Example.yxmd

All comments

markcurry

Hi @DellChristy

I've attached a sample workflow, so hopefully that's along the lines with what you are looking for. If not, can you post an example of your dataset.

There is also a Totally Transpose macro that might help too.... https://community.alteryx.com/t5/Engine-Works/Totally-Transpose-like-totally/ba-p/30222

Mark

Transpose Example.yxmd

pedrodrfaria

Hi @DellChristy

You just need to do a transpose and then a summarize. See attached for a quick example below:

Dataset before:

After:

Thanks,

Pedro.

Pivot - Convert Rows to Columns.yxmd

DellChristy

@pedrodrfaria, That would be great if I were trying to summarize the data, but I'm not. With each row containing a specific piece of data, like name, department, or score, I need to have a table with, for example, name, department, and score columns and a row for each person currently defined by a column.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703