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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Putting Values From Multiple Rows & Columns into One Single Column

I have data in a format similar to this:

 

 ABC
D###
E###
F###

 

 

I have been able to put A, B, and C under a new column named "Entity" and D, E, and F under a new column named "Description", but I am having trouble putting all of the values into their own column. This is what my expected outcome is:

 

EntityDescriptionAmount
AD#
BD#
CD#
AE#
BE#
CE#
AF#
BF#
CF#

 

Any help is very much appreciated!

Alteryx Certified Partner
Alteryx Certified Partner

@brittany_harn,

 

This is pretty straight-forward and a use of the TRANSPOSE tool (using a group by function):

 

Capture.PNG

Please take a look at the attached workflow and let me know if you need any further assistance.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.

@MarqueeCrew

 

Thank you so much for your help!! I didn't realize it was as simple as that!

Labels