Putting Values From Multiple Rows & Columns into One Single Column

brittany_harn

I have data in a format similar to this:

	A	B	C
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:

Entity	Description	Amount
A	D	#
B	D	#
C	D	#
A	E	#
B	E	#
C	E	#
A	F	#
B	F	#
C	F	#

Any help is very much appreciated!

MarqueeCrew

@brittany_harn,

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

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

Cheers,

Mark

Putting Values.yxmd