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!
Solved! Go to Solution.
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
@MarqueeCrew
Thank you so much for your help!! I didn't realize it was as simple as that!