Hi All,
Been spinning my wheels quite a bit. I need certain column headers (A-F) to become a cell and for the value to come along with it. I would need the rows to repeat for every column (A-F). I put a visual on what my end goal would be. This would also be happing for multiple names, not just one.
Thanks.
What I have | ||||||||
Name | ID | Entity | A | B | C | D | E | F |
Guzman | 1010 | Company | 0 | 0.2 | 0 | 0.8 | 0.2 | 0 |
What I need | ||||||||
Name | ID | Entity | Department | Value | ||||
Guzman | 1010 | Company | A | 0 | ||||
Guzman | 1010 | Company | B | 0.2 | ||||
Guzman | 1010 | Company | C | 0 | ||||
Guzman | 1010 | Company | D | 0.8 | ||||
Guzman | 1010 | Company | E | 0.2 | ||||
Guzman | 1010 | Company | F | 0 |
Solved! Go to Solution.
Hi @erickg413, can you setup the config of your transpose tool to mimic what I have in my screenshot below and confirm if it gives you what you are looking for?
You will have to use a Select tool after the Transpose to rename the column to Department.
Hope this helps!