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 · Accepted solution]

@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

[brittany_harn]

@MarqueeCrew

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