community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Transforming Data

Meteoroid

Hello everyone!

 

I am trying to transform my data into a usable format for my needs. There has to be a way to do it, but I cannot figure it out!

 

 I have this:

 

Company

Account

Month 1 total

Month 2 total

Month 3 total

A

001

100

50

75

A

002

350

75

240

B

001

100

90

85

B

002

25

70

18

C

001

1000

400

40

 

But, I need to end up with this:

 

Account

A

A

A

B

B

B

C

C

C

001

100

50

75

100

90

85

100040040

002

350

75

240

25

70

18

  

 

003

 

 

 

 

 

   

 

 

I have tried using the Crosstab tool and the Arrange tool to get the desired result, but still am unable to figure it out. Any ideas would be greatly appreciated!

 

Thanks,

April Mehok

Atom

Here's how it can be done. See attached workflow.

 

 

As you can't have duplicate column names, I have moved the column names you require down to the second row.

Labels