Rows converting to cols (customer transpose)

Alteryx_user_aK

Hi,

I have a custom requirement to transpose the data. here is sample data

PrimKey TransposeKey C1 C2 C3 C4

111 BBB X 10 ER 33

111 BBB Y 30 PK 35

111 CCC Z 12 RT 24

I need output as

PirmKey TransposeKey C1 C2 C3 C4 TranposeKey1 C11 C21 C31 C41 TransposeKey2 C12 C22 C32 C42

111 BBB X 10 ER 33 BBB Y 30 PK 35 CCC Z 12 RT 24

Please let me know which tool (set of) can be useful fixing this issue.

Thanks in advance

Transformation

Accepted answers

binu_acs

@Alteryx_user_aK One way of doing this

Transpose_120423.yxmd

Christina_H

Here's another option

Rows to columns.yxmd

All comments

martinding

Hi @Alteryx_user_aK,

Here is one way to do it:

Crosstab Example.yxmd

binu_acs

@Alteryx_user_aK One way of doing this

Transpose_120423.yxmd

martinding

@binu_acs Nice use of the Formula + Dynamic Rename tool!

Raj

had a try , you can use the logic

might help

New Workflow5.yxmd

Raj

@martinding @binu_acs great logic !!

Christina_H

Here's another option

Rows to columns.yxmd

Alteryx_user_aK

Hi all

I appreciated your quick support. I tried all solutions, all are working as expected. I am going with solution provided by Christina_H

Thanks and Regards

Alteryx_user_aK

Hello martinding,

When I tried using your solution I faced one issue.

when PrimKey changes, it does not come to next line. All primKey comes on same line.

ideally, new PrimKey should be on new line (next record)

111 .....

222 .....

444...

333 ...

Is there any quick fix in your solution for this requirement ?

Thanks in Advance

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703